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

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

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.