Hi,
I have a Access table which stores images (datatype oleObject). I have imported that table into SQLServer (the datatype of the field is IMAGE) and I am trying to read the the table using C#. I have successfully read the data and have written the images (each image is a file) into a file. When I try to open the file, I am not able to read it.
The reason is that when I have imported the access table into SQLServer, OLEHeader was added to the IMAGE records. Unless I remove the OLEHeaders from the images, I will not be able to open the image files (that I stored locally).
Please let me know if anybody has come across this situation or if anybody knows abetter way of importing IMAGES into SQLServer without the OLEHeaders.
This is REALLY IMPORTANT to me.
Thanks
I have a Access table which stores images (datatype oleObject). I have imported that table into SQLServer (the datatype of the field is IMAGE) and I am trying to read the the table using C#. I have successfully read the data and have written the images (each image is a file) into a file. When I try to open the file, I am not able to read it.
The reason is that when I have imported the access table into SQLServer, OLEHeader was added to the IMAGE records. Unless I remove the OLEHeaders from the images, I will not be able to open the image files (that I stored locally).
Please let me know if anybody has come across this situation or if anybody knows abetter way of importing IMAGES into SQLServer without the OLEHeaders.
This is REALLY IMPORTANT to me.
Thanks