Send Report to Excel in Access 2007

H

hlock

In 2003, I used to be able to send a report to excel so that is was grouped.
Now when I open a report in 2007, my export to excel icon is greyed out.
What am I missing?
 
J

Jeanette Cunningham

Sorry about the bad news - this option is not available in A2007 or in the
future.
The reason comes from Microsoft losing a legal battle.
To export, you can export the query behind the report using
TransferSpreadsheet. VBA help explains how to do it.

Jeanette Cunningham
 
E

Evi

So now I have to keep my Office 97 CD so that I have a decent Help file for
Access and I have to keep my Office 2000 CD so that I can export reports.
I think I might give 2007 a miss.
Evi
 

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

Access 2007 Analyze with Excel 2
Access Report to Excel Worksheet 2
Exporting from Access to Excel 3
Exporting Report to Excel 2
open 2003 db in 2007 - report won't export to excel 1
Converting Data in a Report to Excel 9
Exporting a Report in Access 2007 to Excel 1
Exporting to Excel 3

Top