Question: how to export data from access to excel pivot table?
Answer: Start with a blank Excel workbook.
Select Data, From Access.
Browse to your Access database and click Open.
The Select Table dialog shows a list of all the tables and queries in the database. ... 
In the Import Data dialog that appears, choose to create a pivot table report and click OK.