Filtering and exporting data to Excel for pivot tables

[wesrockin]

I have an Access database with millions of records. I am only interested in a subset of records (250,000+) that I would like to analyze in an Excel pivot-table. My issue is; how do I best export this information to Excel. I've tried filtering and exporting, but all records are exported. I've tried copy and paste but only 65K are allowed. Is there a better way to do this, perhaps linking the Access database?



Thanks,
Wes

[CJ_London]

if this is a one time exercise, copy and paste 60+k records at a time.

Alternatively look at the transferspreadsheet function

Otherwise probably better to link to Access from Excel.

Also, presume you know that access does has a pivot query