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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

What type image are the images?

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.