I have a type conversion problem. Or maybe it's a COM problem.
I want to copy a table from MS SQL Server over to a MS Access table.
Everything is going just fine, until I now encounter
a field in the SQLServer table with data type "image". I'm working in C++
and ADO, but answers from VB programmers are welcome.
I work like this:
GetADOField(AccessTable, "A1")->Value =
DoubleVal(GetADOField(SQLServerTable, "A1")); // This works fine
GetADOField(AccessTable, "Category")->Value =
LongVal(GetADOField(SQLServerTable, "Category")); // This works fine
But how to make it for the image? There must be more choices (other than
"LongVal", "DoubleVal"...) that applies to an image, but I can't find it
I saw the AppendChunk function, is this the way to go? In that case, how do
I use it?
In MS Access the corresponding data type for the "image" is "ActiveX data
object". I think it's correct.
Thankful for any help!
Best Regards / Per