Export Access Pivot Table Results to Excel

graviz

Registered User.
Local time
Yesterday, 22:16
Joined
Aug 4, 2009
Messages
167
Is there any way to export a pivot table from access to Excel? I have a couple Excel templates that I paste the pivot table results from access into and it populates the data in a format I need for some slides. I've tried a crosstab query but it's not a option. Is there any way to use vba to export a pivot table view of a table or query to Excel? Thanks
 

Users who are viewing this thread

Back
Top Bottom