excel pivot export to access

[andriil]

Hi all!
I have a pivot table in excel, and I want to export it to access (as a table).
The problem is that (i) the pivot is based on external source I have no
direct access to, and (ii) I can't convert it to table in excel (for further
exporting to access), as it counts a lot more than 65536 rows.
Is there a simple and beautiful solution for that?
Thank you very much!

 

[John Nurick]

I've no experience with Excel pivot tables, but I'd try this:

1) make a copy of the workbook
2) select the pivot table and Copy.
3) Paste Special|Values.

This normally produces a range of simple data values. Tidy it up and
import it to Access.

 

[andriil]

This won't work. what I have to do is importing all the data the pivot
consists of. I could make a table from the pivot in excel (doubleclicking on
the total), but it has a lot more rows than excel sheet... and if I paste the
table as values (or simply try to import it as is) it only imports the
visible rows and fields...
Thank you any way! I think, I'll try to post this question in "excel
programming"...