Get Picture from Access Database

T

terri

I have an Excel (2003) file coded to get data from an Access database using
DAO recordset objects. My only issue is that the database contains embedded
OLE objects (graphics files -- bmps and jpegs) that I need to insert into the
worksheet.
Using QueryTables to transfer the data returns a static value of '21
whereever the OLE field contains a file. (I do not have the option of
changing the database to use external files -- I am stuck with the
embeddeding.)

Is there any way to insert a recordset OLE object (either DAO or ADO) into a
worksheet? If not, is there any way (from Excel) to copy a recordset OLE
object to the clipboard -- where I could then paste it into the worksheet?

Any insight would be greatly appreciated.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top