467,143 Members | 1,206 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,143 developers. It's quick & easy.

Export PivotTable Access to Excel


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
  • viewed: 3052
2 Replies
Expert Mod 8TB
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
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.

Similar topics

5 posts views Thread by Simon | last post: by
1 post views Thread by smaczylo@gmail.com | last post: by
3 posts views Thread by =?Utf-8?B?YzY3NjIyOA==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.