On Wed, 2 Jul 2008 10:09:21 -0700 (PDT), stuart
<stuart.medlin@ncmail.netwrote:
I'm pretty sure an Image field holds the actual bytes of the image.
You should be able to extract those bytes and write them to a file in
the file system.
OLE fields are MUCH different, contain all kinds of decoration, and
there is no simple conversion between the two.
Access (at least until A2007) is not a great tool for storing images,
so you're better off with them in the file system anyway.
-Tom.
Quote:
>We have a forms application that captures comments digitally entered
>by an inspector and saved as an image in Sql Server. The manager of
>this inspector wants to be able to transfer the data in Sql Server to
>Access 2003 table. However, when I try to export the data into an
>Access table and into an OLE field, the field displays the information
>as "long binary data".
>
>Is there a way to transfer the data so the field in the Access table
>can be displayed?
>
>Thanks.
>
>Stuart
