How to export an Image field from Sql Server to Access 2003

Question posted by: stuart (Guest) on July 2nd, 2008 05:15 PM

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

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

Tom van Stiphout

Guest

n/a Posts

July 3rd, 2008
04:25 AM
#2

Re: How to export an Image field from Sql Server to Access 2003

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:

Originally Posted by

>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

Not the answer you were looking for? Post your question . . .
182,263 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).