Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you export a pivot table into Access?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you export a pivot table into Access?
Hi Tracy
You can copy the PT and paste Special Values. Alternatively, you can use the GetPivotData function to extract values from the PT. For help with GetPivotData take a look at Debra Dalgleish's site http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Tracy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you export a pivot table into Access?
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 "Roger Govier" wrote: Hi Tracy You can copy the PT and paste Special Values. Alternatively, you can use the GetPivotData function to extract values from the PT. For help with GetPivotData take a look at Debra Dalgleish's site http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Tracy" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you export a pivot table into Access?
Hi Tracy
Well save the data from whatever GetPivotData formulae you set up, and export it to wherever you wish. -- Regards Roger Govier "Tracy" wrote in message ... 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 "Roger Govier" wrote: Hi Tracy You can copy the PT and paste Special Values. Alternatively, you can use the GetPivotData function to extract values from the PT. For help with GetPivotData take a look at Debra Dalgleish's site http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Tracy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems saving pivot table in same workbook as export query | Charts and Charting in Excel | |||
Is there any way to export a .xls table to Access .mdb without Acc | Excel Discussion (Misc queries) | |||
PIVOT TABLE FROM A FORM IN ACCESS | Excel Discussion (Misc queries) | |||
Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
Pivot Table against an Access Database | Excel Discussion (Misc queries) |