Data from Pivot table in Excel to Access

D

dhanushram

Joined
Apr 28, 2007
Messages
1
Reaction score
0
I have the following problem:
I have 3rd party research data which is in the Pivot table form. I want to export the data in the Pivot table to Access.

I tried double-clicking on the data which would give me a table. But that table contains only 65536 rows and I know that the source data should be more than 65536 records.

Any help?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
Access #Error & Excel Pivot 0
Pivot table multiple filters 2
Pivot using 250,000 rows of data in Excel? 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot Table Question 2
Excel 2010 Pivot Table 2
Playing back a Pivot Table macros 2

Top