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

Outlook 2021 export question 0
Exporting Outlook 2007 contact list without losing groups 0
How to make report 0
Access 2002 change report header text 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Adding Cost Field to Appointment 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0

Top