troubleshooting Question

Writing data from Access to Excel produces a blank document

Avatar of Ian Wallace
Ian Wallace asked on
Microsoft AccessVBAMicrosoft ExcelMicrosoft Office
2 Comments1 Solution20 ViewsLast Modified:
Hi,

I have a reporting package which is written in MS Access.

Some of the reports need to be produced in Excel, so the Access database grabs the data it needs from SQL and then write the Excel document (They are all a bit quirky and have to be formatted a certain way so a DoCmd.OutPutTo won't work).

Some users are having issues where the document is created, the headers are there, the column headers are there, the page formatting has been done, but theres no data!  Some of them can close the Access database, reopen it and then it will work, but others haven't been able to create these reports for weeks.

I've made sure they are all on the same versions of Windows and Office so am now stuck.

Any help would be appreciated!
ASKER CERTIFIED SOLUTION
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 2 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 2 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004