Send Report to Excel in Access 2007

  • Thread starter Thread starter hlock
  • Start date Start date
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?
 
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
 
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
 
Back
Top