Can you export a pivot table into Access?

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

Guest

I have a program in which I can create pivot tables to get data. The problem
is that I want the data so I can merge it with some other data. Is there a
way to export pivot table data?

Thanks
 
Actually, I was looking for more of a file that would have the column and row
headings and then the data. It seems like the GetPivotData function has all
of the info, but I want to export to elsewhere.

Tracy
 
Hi Tracy

Well save the data from whatever GetPivotData formulae you set up, and
export it to wherever you wish.
 
Back
Top