How do I export a report to Excel in Access 2007



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?

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

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!


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