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.