Prev: Matching the first 3 letters of the field
Next: Chart problem
From: stuart on 2 Jul 2008 13:09
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
From: Tom van Stiphout on 3 Jul 2008 00:15
On Wed, 2 Jul 2008 10:09:21 -0700 (PDT), stuart
<stuart.medlin(a)ncmail.net> wrote:

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.


>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
 | 
Pages: 1
Prev: Matching the first 3 letters of the field
Next: Chart problem