Can you export a pivot table into Access?

T

Tracy

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
 
T

Tracy

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
 
R

Roger Govier

Hi Tracy

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