Saving OLE objects to disk

[Steve]

Hi All,
I have a database that has a table which includes
pictures. There is one field that stores a picture in
each record. Is there a way that I can save all of the
pictures to a folder on my disk without having to
download them one at a time? Any help would be greatly
appreciated.

Thanks,
Steve

 

[Stephen Lebans]

Have a look here:
http://www.lebans.com/oletodisk.htm
NEW - Apr. 14/2002 A2KExportOLEtoJPEG.zip A2K ONLY! This version
saves the entire contents of a table containing OLE Object Images to
disk based Jpeg files. User selectable compression rate. Version 1.5

Use the A2KExportOLEtoJpeg above instead of these following older
versions!

SaveOLEtoBitmap.zip is a database containing functions to allow you to
save the contents of an OLE Field to a disk based Bitmap file.

SaveOLEtoBitmapAuto.zip is a database containing functions to allow you
to save the contents of an OLE Field to a disk based Bitmap file for the
entire table automatically.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.