Extract raw file from any OLE Object field

[WinterBoy]

Hi,

I have a database that has numerous file stored in OLE Object fields. We want to use this database with a new .net based frontend.

Unfortunately, the files have not been stored in their raw binary format but have been inserted with some sort of OLE headers.

I've been searching around and have found references to stripping the first 78 bytes to get an image back.

The problems are these:

1. Not all the records hold images (most of them don't)
2. The file formats are varied (pdfs, word docs, outlook .msg files)

Does anybody know of an effective way of stripping the OLE headers from these files (regardless of what the original file format was).

The original filename has been retained in a separate field.

Thanks.

[zaidlig]

I'm not sure I understand what you are trying to do. But you should be able to activate the OLE object and save it in its original format. Then convert to to whatever you want.