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!

MS Access reports export to Excel

Status
Not open for further replies.

desi5pure

MIS
Mar 29, 2008
38
US
We use MS Access 2007. When I run any report, it shows report but does not give me option to export to Excel. I can export to other formats (pdf, xps, etc.) but not to Excel. Excel option is grayed out (disabled perhaps?).
Where can I find setting that will allow me to export reports to Excel?
 
Desi,
With earlier version of Access (2003), we could use File/Export or we could use Tools/Office Links to export an Access report to Excel.
Jeff
 
Desi
You cannot export access 2007 reports to excel. however you can export the query results to excel or export the report into word.

chris
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top