How do I export a report to Excel in Access 2007

D

davewill

I have always been able to export a report to Excel but with Access 2007
Excel isn't an option when exporting a report. Can I still do this?
 
J

Jeff Boyce

As I understand it, Microsoft 'settled' a lawsuit by, in part, agreeing not
to export reports to Excel. This feature is no longer available in Access
2007.

The work-around I came up with (my users INSISTED that they continue to be
able to export reports to Excel) was to export the reports' underlying
queries to Excel. That still works.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export to XML - error 31532 0
office link feature to excel in Access 2007 1
Export from Access 2007 Report to excel 3
Macro to export query to Excel 2
Can't Export Report to Excel 3
Can't export to EXCEL file 1
Export Data from Report or Query to Excel 1
Export Access Report to Excel 4

Top