G
Guest
Hi there,
I have been trying to programmatically (using VBA code in Access) insert a
section of an spreadsheet into an Access OLE object field so that if I go to
the table and I double click on the field it shows me the content as Excel.
Manually this can be done by right clicking on the field in the access table,
selecting MIcrosoft Excel Worksheet and then copy the part that I want into
the Worksheet.
I have tried several approaches (like one mentioned in other treads
"infileData", and in the support web site "ACC: Reading, storing, & writing
Binary Large Object (BLOBs)") but in all of them I ended up with a Long
Binary data blob that cannot be open from the table view (message" A problem
occurred while Microsoft Office Access was communicating with the OLE server
or Active Control")
Thank you very much.
I have been trying to programmatically (using VBA code in Access) insert a
section of an spreadsheet into an Access OLE object field so that if I go to
the table and I double click on the field it shows me the content as Excel.
Manually this can be done by right clicking on the field in the access table,
selecting MIcrosoft Excel Worksheet and then copy the part that I want into
the Worksheet.
I have tried several approaches (like one mentioned in other treads
"infileData", and in the support web site "ACC: Reading, storing, & writing
Binary Large Object (BLOBs)") but in all of them I ended up with a Long
Binary data blob that cannot be open from the table view (message" A problem
occurred while Microsoft Office Access was communicating with the OLE server
or Active Control")
Thank you very much.