Extract .BMP images from an access table (or with same table imported into SQL server)
Posted on 2004-03-30
We have an access table that contains 3,700 staff info and photos.
These are stored in .BMP format in an OLE Blob filed which is displayed
as "Long Binary"
I'd like to extract the photos so that I can add them to the door access
Can you please tell me how I can extract the photos and save them as
"Bloggs Joe.BMP" etc, preferably all at once rather than 1 at a time.
We also have an SQL server and have imported the access table into it, if that makes things easier.