M
maltobelli
I have a project where users enter information into an Access front-end with
an SQL Server backend (a project run by another group). I need to pull the
information from SQL and insert it into a Word document. All is going well,
except for a field within the database which contains an image of a chemical
structure. According to the database owner, the control in Access is an OLE
object where users "paste" these images that they copy directly from Chemdraw
or ISIS, two programs for generating the chemical structure images. the OLE
Data is saved to the database in an IMAGE field.
I'm currently using GetChunk to grab the LongVarBinary field and save it to
a file, but I can't get the image to display. I have no idea what type of
content was pasted into the OLE field for each record, it may be one of
several data types and none of the possible extensions seems to be working.
So my question for any gurus is: Is it possible to utilize this OLE/image
data? How would I go about bringing it into Word?
an SQL Server backend (a project run by another group). I need to pull the
information from SQL and insert it into a Word document. All is going well,
except for a field within the database which contains an image of a chemical
structure. According to the database owner, the control in Access is an OLE
object where users "paste" these images that they copy directly from Chemdraw
or ISIS, two programs for generating the chemical structure images. the OLE
Data is saved to the database in an IMAGE field.
I'm currently using GetChunk to grab the LongVarBinary field and save it to
a file, but I can't get the image to display. I have no idea what type of
content was pasted into the OLE field for each record, it may be one of
several data types and none of the possible extensions seems to be working.
So my question for any gurus is: Is it possible to utilize this OLE/image
data? How would I go about bringing it into Word?