Exporting from Access to Excel 1

[shirsch]

I am trying export a report to excel. The report is based on query. The report has calculates summary totals and has some formating. I can export the report to Word, and that except for some separation lines not printing the report is fine. But when I export to excel I only get one text cell and no data at all.

 

[Hmadyson]

I believe that exporting reports to excel only exports the information in the detail section, so if you skip the detail section and only have subtotals and total information, none of it posts out. You can export the underlying query to excel if you need the underlying data.

 

[HitechUser]

Hmadyson is correct, Microsoft says totals are lost.. See this link... Microsoft.
That being said you still should be able to get the detail information. Hmmmmmm.

Are you doing this with VBA or are you using the menus??

Good Luck.

 

[SilentAiche]

shirsch,

I just did a brief test and was able to export a simple report (query-based), with column totals, directly from Access to Excel.

In report Print Preview mode, click on Tools / Office Links / Analyze It with Microsoft Excel.

Not only did I get all data and the totals, the totals contained the correct formula - not just the value from the Access report. Also, the column headings in Excel were the field names from the Access report design.

I'm using Access & Excel 2002 on Win XP.

Hope this helps!
Tim