Export to Excel more than 900,000 records

[kezza]

I have a database in Access 2003 and need to create a pivot table from it in
Excel. I cannot export it to Excel, as it exceeds the 65,000 records limit.

I have a feeling I can convert my Access table and then import it into
Excel, somehow turning it into a pivot table, but I can't remember how.

Thanks heaps!

 

[Allen Browne]

Perhaps you could upgrade to Office 2007.
Worksheets in Excel 2007 support a million rows.

Other possibilities:
a) aggregate the data (a GROUP BY query that summarizes totals giving you
fewer rows);
b) export to a CSV, and then split it into multiple files.
c) use criteria to export in stages.

 

[david]

Or create a pivot table with an Access Pivot Query, (in Access,
called a Crosstab query) and export the result to Excel

(david)