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!
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!