atadbitslow
Programmer
I am trying to export an Access 97 report to Excel 97, and have each page of the Access report be a separate Sheet in Excel. Is this possible?
Thanks!
Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting an Access report to Excel--multiple pages
- Thread starter atadbitslow
- Start date
- Status
I'm not sure if you are trying to do the same thing I was, but I developed a work-around for this problem. I had the queries that were supplying data to the Access Report output to separate .xls files. Then in Excel, I imported each of the Access output files to a separate Excel worksheet.
Hope this helps.
Richard...
Hope this helps.
Richard...
- Status