Export Access Pivot Table to Excel

G

graviz

Board Regular
Joined
Mar 19, 2009
Messages
93
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.:confused: Thanks!
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Sort by date Sort by votes
You can't, as far as I know: you can export the data but the pivot table view stays behind.
Your best option is to export the data to Excel, and build the pivot there, or just go to Excel and directly build a pivot table with an external data source based on the table / query.

Denis
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Export To Excel .XLSX file
Replies
3
Views
218
Micron
M
S
  • Solved
Export Access Table data to Excel - DoCmd.TransferSpreadsheet function
Replies
3
Views
620
alansidman
A
tourless
  • Question
Pain in the Access
Replies
6
Views
591
alansidman
A
K
  • Question
Exporting Query Data to Excel for making Charts
Replies
3
Views
653
Micron
M
S
  • Question
Exporting 2 tables using 2 queries into one Excel file (2 different tabs)
Replies
0
Views
205
santa12345
S

Forum statistics

Threads
1,214,644
Messages
6,120,709
Members
448,983
Latest member
Joaquim_Baptista

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top