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
 
Top