Exporting Ppivot table from Access to Excel

K

kvalluri

Hi there,

(1) I am working with a huge Access database with 346,722 records
(2) I created a pivot table in Access and that works
(3) Now, I want to export this table to Excel
(4) When I try to do this, it says "No Data" and returns a blank Excel
page

I understand that there is a limitation on the number of lines in
Excel (~64K). But, since I have a massive database file, how can I
possibly export the Pivot table to Excel?

Any comments will be greatly appreciated!

Thanks!!!

rgds
Kaushik
 
P

Pieter Wijnen

You can build a series of queries based of the pivot that break the result
down to manageable chunks
& Export them to the same spreadsheet.

Pieter
 

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

Export to Excel more than 900,000 records 2
Turning a 3 column flat file into a "3D" Table 2
Access #Error & Excel Pivot 0
Exporting to Excel from Access 3
Exporting a table from Access 2003 to Excel 2007 1
Exporting to Excel 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Exporting pivot tables 2

Top