how to link access data to excel's pivot table

G

Guest

I have over 100K records in access, which exceeds the limit of rows in excel.
Can i link excel to access database to pivot the whole table?
 
D

Duane Hookom

You can create a pivot table in Excel that links to a table in Access that
has greater than 100K records.
 
D

Duane Hookom

Open Excel and select Data->Pivot Table....->External data source->Get Data.
Then select Microsoft Access MDB and find your MDB file. Select the
appropriate tables and/or queries and fields.
 
G

Guest

I used a blank spreadsheet, and followed your steps below, I got the message
below
"No data fields have been retrieved"

Thanks, Holly
 
D

Duane Hookom

Are you attempting to select a single table or a query or multiple? Did you
select a query that expects criteria?
 

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

Top