I'm hoping someone can help me with this. I've found that the new pivot table feature in Access 2002 is better in some respects than the pivot table tool in Excel. You can easily group data by month, week, etc. I've created a few pivot tables in Access, and I can export them to Excel from an Access pivot table view by clicking on the "Export to Microsoft Excel" button. I'd like to create a macro to automate this process, but I can't find the command to export the pivot table view, only the raw data. Any ideas?