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
 
Back
Top