Analyse with Excel not available in Access 2007?

P

PE

In Access 2003 I was able to produce a report and then use the Tools>Office
Links>Analyse with Excel to transfer the information to a spreadsheet. I
don't seem to be able to do this in Access 2007. I've tried the 2003 Menu
keystrokes but they don't work. When the report is on the screen I am given
the option on the ribbon to send it to Word as an rtf file but the Excel
button is greyed out.

Is it possible to Analyse with Excel in 2007?
 
D

Douglas J. Steele

The ability to export a report to Excel has been removed.

I believe few people found it worked correctly. You can still transfer a
query to Excel though.
 

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

Analyse with Excel 1
Fields in Checkboxes excluded in Analyse It with Microsoft Excel 2
Analyse Table creates Lookup tables and bloats the db 2
Automating analyse with Microsoft excel 2
Print Preview Ribbon - Excel Button 0
Access 2007 - Export a Report 1
Figuring out MAX LEN in a given column 2
Analyze with Excel in Access 2007 3

Top