By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Export PivotTable Access to Excel

P: 2
Hello...

First, sorry for my bad english...

i have generated many pivot tables in Access 2003. and i want the code to export all of them to one single excel sheet and specific cell.
i have little knowledge about this export function.

i have generated many reports in excel, and save the sheet for information that pivot tables in access. with information in the specifici sheet and specific cell, e generated automatically the reports..

may i know how to export pivot tables to one single excel file?
thanks in advance.
Jun 19 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I'm not an expert on pivot tables but I doubt if you can export the pivot tables themselves. You can export the queries behind the pivot tables and build the pivot tables again in Excel.
Jun 19 '07 #2

P: 2
But the problem is a automatization... my reports have automatically, the information push the different sheet e specific cells and generated the report...

is posssible export many pivot tables or queries with a button VBA?

my queries in access don't have the information i need, the information and values have in pivot table...
Jun 20 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.