Exporting images (ole object) from access to images folderfolder

[nigel.thomson]

Hello All

Is there an easy way to do this?
I have a database that contains records witha image as one of the
fields, what I want to do is export the images to a seperate folder, in
whatever foremat is suitable (gif, jpeg etc)

But i can't work out how to do this

This is all the information i have
The original database was made using access 97, (I have Access 2003)

I have tried using the ole to disk function thingie mentioned in an
earlier post (2002)

http://www.lebans.com/oletodisk.htm

But it keeps coming up with

"sorry this OLE Object contains an unsupported format, Please select a
different record to export"

How do i find out what the ole object in my database is when i look at
the field all it says is "long binary data"

Thanks in advance

[Stephen Lebans]

If thefield in Datasheet view says "Long Binary Data" then you DO NOT have
an OLE object embedded within the field. The field contains plain binary
data which can be anything. Hopefully, the field contains an exact copy of
the original file.

1) What application inserted the binary data?
2) How do you currently view the data in the field?

If you have an associated field that contains the name or at least the file
extension(BMP, JPG, etc) then you can simply save the contents of the field
to a temp disk file with the proper file extension and then set the Picture
property of the Image control to this temp file.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
<ni***********@gmail.com> wrote in message
news:11*********************@i40g2000cwc.googlegro ups.com...

Hello All

Is there an easy way to do this?
I have a database that contains records witha image as one of the
fields, what I want to do is export the images to a seperate folder, in
whatever foremat is suitable (gif, jpeg etc)

But i can't work out how to do this

This is all the information i have
The original database was made using access 97, (I have Access 2003)

I have tried using the ole to disk function thingie mentioned in an
earlier post (2002)

http://www.lebans.com/oletodisk.htm

But it keeps coming up with

"sorry this OLE Object contains an unsupported format, Please select a
different record to export"

How do i find out what the ole object in my database is when i look at
the field all it says is "long binary data"

Thanks in advance

[nigel]

Thanks for the reply

I was given this database to work with, I have no idea what was used to
insert the binary data,
The data type says OLE Object, the field says "Long Binary Data"
the data is currently viewed through a form (sorry I don't know a heck
of a lot about access) , so i am guessing the only way to get the
images is by using screenshots,

oh well it was worth a try

Thanks for all the help

[Stephen Lebans]

You need to save the Long Binary field to a temp file on your drive. You
must ensure the file extension is the correct one, ie BMP, TIF, etc. THen
point the Picture property of a standard Image control to this temp file.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"nigel" <ni***********@gmail.com> wrote in message
news:11**********************@p10g2000cwp.googlegr oups.com...

Thanks for the reply

I was given this database to work with, I have no idea what was used to
insert the binary data,
The data type says OLE Object, the field says "Long Binary Data"
the data is currently viewed through a form (sorry I don't know a heck
of a lot about access) , so i am guessing the only way to get the
images is by using screenshots,

oh well it was worth a try

Thanks for all the help