Ole-object to image

[Bjarne Anker]

Hi,

I've developed an application in Access2K using jet database, but now I want
to move the database to MS SQL Server.
I've designed the database and done some adjustments to the relations, and
now it's time to copy the data.
The copying will be runned automatically for each user, so i have to program
it using recordsets. It works fine, except copying embedded images.
I have a logo field in the mdb-table and when i copy it to SQL Server it
won't show in the form no more.
I've learned that Access adds a *lot* of header information when you insert
an image in an Ole-object field, so those headers are not the same in SQL
Server i guess?

Any tips og funtions to get the image data over to SQL Server?
I've managed to strip the Ole-object headers so i can write the image to
disk and view it. So maybe i have to add SQL Server headers to the file
before i put it back?
Anything would be helpful!

Thanks in advance,

Bjarne Anker

 

[Bjarne Anker]

Nevermind, i found the soultion.
I used GetChunk and AppendChunk to copy the data, and it worked like a
charm..

Bjarne