Exporting Report to Excel

[JimP]

Now that MS-Access 2007 has disabled exporting reports to Excel - do wou
know of a workaround or third party solution for this?

...perhaps exporting to another format (rtf?) first and then to Excel?

 

[Ryan]

Access 2007 makes it easy. Above the ribbon, there is the round office
button. Just to the right of that there is a little down arrow which opens
your quick access toolbar. If you open that, click more command, you can add
the export to excel spreadsheet button, or to any office application for that
matter.

 

[Ryan]

Check out this documentation.

http://kbalertz.com/934833/cannot-export-report-Excel-format-Access.aspx

 

[JimP]

Thanks Ryan,

However, I don't think this is feasible in this situation.

1. MS-Access is being used as a report writer for a SQL Server db
2. There are several thousand reports and queries
3. There are several thousand users across numerous clients, none of whom
know anything about MS-Access. They are accustomed to pressing a button on a
toolbar - and the report exports.

Is there anything else that can be done?

Jim