Converting Data in a Report to Excel

[Wendy]

In Office 2003 you were able to export data in a report directly to Excel by
clicking on a button. In Office 2007 the "Excel button" is grayed out when
you are viewing a report. I read in the Help of Office 2007 and it appears
you can no longer export data from a report. I wanted to make sure I wasn't
missing something since I could do this previously. Thoughts?

 

[Evi]

You're not missing anything Wendy - it is no longer available. If you do a
search in Google on this group for Excel And Access 2007 you'll see that
this feature has been missed but that the MVPs are already working on
workarounds.
Dev Ashish has some good looking code to let you export the query on which
your report is based
http://www.mvps.org/access/modules/mdl0035.htm

Evi

 

[Jeanette Cunningham]

Wendy,
I have heard an easy workaround by exporting as an html file which can they
be opened in excel. I haven't tried this yet but have heard that is works.

Jeanette Cunningham

 

[Evi]

Hey for some reason, I've got some random little gif attached to my message.
I've virus checked it and its clean but I don't know where it came from.
Evi

 

[Jeff Boyce]

Wendy

Microsoft "greyed out" the capability of exporting an Access report to Excel
.... you can still send to Word, but no longer to Excel directly from the
report.

Here's a work-around I'm using:

Export the QUERY that would feed the report, instead of the report
itself.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Wendy]

Thanks to everyone for the advice!

I am working with the database developer to go back to the query that
initially created the report. Not as easy as it used to be but it will work.

Thanks again!

 

[Wendy]

I tried this. It worked somewhat. It creates a separate html page for each
page in the report, so there is a little cutting and pasting to do, but it
did work.

Thanks!

 

[Jim Conrady]

Jeanette, Wendy, et al,

I did the export to html trick and it worked. It is cumbersome, but got the
job done. I have a summary report... 15 pages of totals. It did output them
and formatted it pretty close to the way I had it. Two things to watch:

1. It is slower than an old Dodge. Took about 15 minutes (more?) to output
a 15 page report.
2. It puts every page in a separate html file. I have not tried to do any
other settings to fix that as it only takes me about 10 minutes to combine
them all. Perhaps it can be done easier.

But, the good news, I got it to work. I had been working on this off and on
for a week, so I am here to tell you that searching the MS Knowledge Base
works... thankts.

Regards,

Jim

 

[Bill Smith]

Jeanette, Wendy, et al,

I did the export to html trick and it worked. It is cumbersome, but got
the
job done. I have a summary report... 15 pages of totals. It did output
them
and formatted it pretty close to the way I had it. Two things to watch:

1. It is slower than an old Dodge. Took about 15 minutes (more?) to
output
a 15 page report.
2. It puts every page in a separate html file. I have not tried to do
any
other settings to fix that as it only takes me about 10 minutes to combine
them all. Perhaps it can be done easier.

But, the good news, I got it to work. I had been working on this off and
on
for a week, so I am here to tell you that searching the MS Knowledge Base
works... thankts.

Regards,

Jim

Jim,
When I need to export a report to excel, I do it from the query I used to
create the report. Works every time. This won't bring the headers or
footers, but all the data is there.

 

[Jer]

I have the same problem, however the reports contain calculations, groupings
with subtotals with calculations., totals with calculations and grand totals
also with calculations that I need in the Excel spreadsheet. The input
query does not contain these groupings, calculations, subtotals, or totals.
A lot of work is required to put these groupings, calculations, subtotals and
totals into a series of queries to be exported to excel.

The HTML solution listed below does store the report one page per html file
and each page can be opened in Excel 2007 one page at a time.

Both of the solutions work, with a lot of work and extra effort. I find
neither to be a satisfactory solution!