Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extracting an Image from an Access Database and Importing into Excel

Status
Not open for further replies.

jadedinvasion

Programmer
Feb 8, 2005
22
CA
I have an image (bitmap) stored in a table in an .mdb file and was wondering how to extract it out onto an excel spreadsheet.

I've been digging around and haven't anything all that helps.

Any Ideas?
 
I think you can right-click on the image, copy, & paste into Excel....

I have great faith in fools; self-confidence my friends call it.
-Poe
 
I'm sorry I should have been more specific.

I was wondering how to do it with VBA. I'm pretty sure the conventional ways of exporting data from Access to Excel wont work for images.

I was just wondering if there was some OLE object I need to use to get the picture from database onto the spreadsheet.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top