Import from Access to Excel, via pivot table

[Ali]

I'm currently using a database that is about 67,500 rows, and it
increases weekly by about 2,300. Every week I follow a process where I
import data to Excel from Access in pivot table form. This week, I
suddenly got this error message: "Pivot table list could not be
imported correctly by Excel and data may have been lost. If you need to
work with this data in Excel, contact the author of the webpage for
information about connecting to the original data source." I didn't do
anything differently from my previous weeks. I tried deleting this
week's information from the database and doing last week's process
over, and it worked fine. I'd appreciate any help.

 

[steven1001]

the pivot table will operate happily on more than 64k rows but you will
have to change from storing the underlying data in the excel
worksheet.

see pivot table wizard, step 1 of 3, and select external data source.

Alternatively extract the source data into a text file in csv or tab
delimited format (or another database) and attach to that as external
data if you want to keep a copy of the data locally on your machine for
some reason.

regards..