Exporting Pivot Table to Excell - only want filtered records

[Jennifer227]

I created a pivot table in Access 2007 and there is a button under the Design tab to automatically export your pivot table to Excel. However, in addition to the pivot table, it's exporting all the raw data from the main table. My main table contains over 1 million records. I'd just like the pivot table and the filtered data to export to Excel. Is there a way to do this? My project is due in 15 days. Need to know which direction to go soon. Thanks!

[kennejd]

In a module(or macro), try the docmd.transferspreadsheet method. Be sure to update the column headers in your query.