Access Report to Excel

[Guest_imported]

I am trying to go from an Access report into Excel. The problem is that it will only import the raw data. I need the custom subtotals, totals, and averages to automatically populate in Excel. Does anybody know how to do that? Thanks.

 

[CosmoKramer]

Click on File | Save As/Export... | Select To an External File or Database and Save As a Microsoft Excel file.....

 

[Guest_imported]

PLEASE HELP!!! Thank you, but the report I have groups by categories and there are subtotals that don't export to Excel. Does anybody know how to export which includes subtotals based on groupings ??? Thank you!

 

[VogonPoet]

The basic export functions for a report are pretty limited. I can think of two ways to approach this:

1 - export the data to Excel and use the subtotals in Excel. This is the low tech way, and if it works in your situation, I'd use it.

2 - write some code to read the recordset line by line and write the data to Excel. This way, everytime you encounter a change in one of the subtotaling fields, you create the necessary formulas/totals in Excel. I've created some procedures in the past to create "pretty" Excel files and it is always a pain. The nice thing about the code approach, is it allows you to do a lot of other nice things with the output (create separate tabs for each subtotal section, indent sections below header sections, etc.)

If you decide to go the code route, let me know, I can email some databases I created in the past (the code is too long to post here)

Michael

 

[bsimmons]

Can you forward me your sample database(s) and whaty you wrote. I too, am in a similar situation.

 

[VogonPoet]

bsimmons,

What is your email address so I can send you the sample code?

Michael
mhodes@earthlink.net