Export to Excel

I have some records that I want to export to Excel, There are are number of int, varchar & date values which all export fine.

The sourse dataset is in MSAccess and is an oleobject datatype.

The images do not export
BrogrimInformation Systems Development ManagerAsked:
Who is Participating?
Nick67Connect With a Mentor Commented:
Are you able to post a SMALL sample database and more detail about how you are doing the export.  Normally, most experts do not store images directly in the database as OLE objects because they make for huge file size.  The more conventional approach is to store images in a folder and store path and filename information in the database.

A sample db and excel sheet and much more detailed explanations of how you are exporting and what results you'd like need to be forthcoming.
What type image are the images?

Jeffrey CoachmanMIS LiasonCommented:
<The sourse dataset is in MSAccess and is an oleobject datatype.>
It is not clear what you mean by this.
A "dataset" cannot be OLEObject, ...but a field "Datatype" can be...

In any event, OLE field data will not export directly from Access to Excel.

I use a technique similar to what Nick67 posted, I am sure he can help you further...


BrogrimInformation Systems Development ManagerAuthor Commented:
Used the store path, thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.