Export Access Pivot Table to Excel

[graviz]

Does anyone know how to export an Access pivot table to Excel. I've used the docmd.transferspreadsheet in the past and it works great for raw query data, however I cannot figure out how to export the pivot table view in a query. Thanks!

[whphillips963]

I'm working on a similar problem. I've noticed that when I was designing my Access 2007 PivotTable, there was a button which exported the results to excel exactly as it appears in access - as a pivot.

So far, the best I've found is a link that showed how to put that button in a customized ribbon menu. The button is called PivotExportToExcel. Not sure how it works in Access 2003.

Here's an article that has the information I needed to figure out how to do it.

http://www.databasedev.co.uk/access2007ribbon.html

My problem now is that, I'm trying to deploy the solution and for some reason, this particular PivotExportToExcel item doesn't show up in the compiled version. Other items do.