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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2007 report - output to Excel is not an option?? 3

Status
Not open for further replies.

KLBacon

IS-IT--Management
Feb 19, 2009
1
US
I have a new installation of Office 2007. While attempting to output an Access 2007 report to Excel, I do not find Excel listed as an option. I suspect I need an "Add in" but, I am not sure?! Can anyone shed some light on the matter, please?

Thank You,
Kevin
 
Hi,
The Export to Excel tool is NOT available when you have a Report selected. The only workaround that I found is to create a query using all fields from the report, and then exporting the query to Excel.

Hope this helps!

Best,
Blue Horizon [2thumbsup]
 


Blue said:
The Export to Excel tool is NOT available when you have a Report selected.
Thank goodness!!!

If there is one thing I hate imported into Excel, its a REPORT! Yuk! puke!

Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top