how to link access data to excel's pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
You can create a pivot table in Excel that links to a table in Access that
has greater than 100K records.
 
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.
 
I used a blank spreadsheet, and followed your steps below, I got the message
below
"No data fields have been retrieved"

Thanks, Holly
 
Are you attempting to select a single table or a query or multiple? Did you
select a query that expects criteria?
 
Back
Top