How to export pivot table from access to excel using vba code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Can any one tell how can i export pivot table from access to excel using vba
code.

thanks
 
I don't know, but what I've done in the past was to export the data as a
table to Excel and make the pivot table in Excel. Excel has pivot-table-
making features beyond those of Access, and it seems easier also.

Hope this helps,

Sam
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Pivot table 1
Access #Error & Excel Pivot 0
VBA Code Required 1
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
How to export table from outlook into ms access table? 0
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Pivot Table Form - Display Null Values as "0" on Data Axis? 2
Pivot Table 2

Back
Top