Export OLE pictures to .jpg files

[DataMinerHome]

Hi, I have inherited a table with an OLE field that stores pictures.
The entries in the field look like this:
microsoft photo editor 3.0 photo
or
ms_clipart_gallery.2



I want to export these pictures to .jpg files. How do I do this?

Thanks for any help you can supply!

 

[DCrake]

Do a search on Blob To File

When you look at the table in datasheet mode what does the ole field say?

Bitmap Image? Long Binary Data? Something Else?

 

[DataMinerHome]

In datasheet mode the entries are:
microsoft photo editor 3.0 photo
or
ms_clipart_gallery.2


I am trying to make my way through the BLOB search stuff. Any additional info would be great.

I am really trying to figure out what is the best way to handle image data. I have forms that contain work instructions for a manufacturing area. Many of these need to have pictures included. Right now, some of the pictures are stored in a table as ole, and some are external .pdf files. The database is already at around 1G and we will need to add quite a few more pictures.

 

[DCrake]

Can you post a couple of records with different ole types to test

 

[DataMinerHome]

Okay, I have found a semi- useful article at
"support.microsoft.com/kb/103257"

This shows how to copy a file into the ole field, and then re-export that same file. That workrs fine.

However, when I use this to export the existing files in the table, they are all unreadable. I've tried exporting as .jpg, .bmp., .pdf, and all I get when I try to open them is that the file format is unrecognizable.

 

[DCrake]

What method was used to get the files in to blob in the first place?

 

[DataMinerHome]

I have no way of knowing for sure. I assume probably just using the Access method of right-clicking on the field in the table, and following the Access instructions.