• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Extract .BMP images from an access table (or with same table imported into SQL server)

Hello,
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
system.
 
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.
 
Thanks
Phil Stevenson.

 
0
phil753
Asked:
phil753
1 Solution
 
peter57rCommented:
Hello phil753,

See if this will help you.  I'm not much of a graphics person.

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

Pete
0
 
phil753Author Commented:
Hi Pete,
thanks for your idea, I'd already found this web site and tried all the downloadable apps, but they just report "ActiveX control not available".

Any other ideas please?
0
 
Steve BinkCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:

PAQ/Refund

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

RoutineT
EE Cleanup Volunteer

0
 
NetminderCommented:
PAQed, with points refunded (250)

Netminder
Site Admin
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now