By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,669 Members | 2,546 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,669 IT Pros & Developers. It's quick & easy.

Access 2007 attachment data type - can the attachment be exported

P: 43
Hi - I currently use Access 2003 and have documents stored in an OLE data type field. I want be able to write a query that contains various other data elements from the table plus the OLE field and export these to an excel file. The query itself shows the document in the OLE field, but when I export the spreadsheet to Excel, the field holding the document shows up blank.

Doing research, I saw Access 2007 had a different data type called attachment. Am wondering if I'd have better luck with this trying to export this to a spreadsheet and still being able to see / open the document.

Maybe I'm barking up the wrong tree (as in maybe a field in Excel can't hold an OLE embedded object), but it's clear I have absolutely no idea what i'm doing.

Please help if you have any information I'd find valuable.

Aug 27 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.