Pivot Table with external data source in Access

T

Terence

I have an Access database with tables that link to data
via ODBC. I then created some queries in Access from
those tables. Now I am trying to create a Pivot Table in
Excel to link to my Access queries.

I choose external data source in Step 1 of creating a
Pivot Table. Then in Step 2 I click on Get Data, then MS
Access Database as my Data Source. Next Microsoft Query
opens up and I select my Access Database, but then I have
nothing to select - no tables or queries.
 

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

Similar Threads

Help creating a search form in Access XP 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Slicers and Calculated Items in Pivot Table 2
Excel 2007 pivot table using analysis services cube as data source 0
Adding data to MS Access from csv file 0
Pivot Table Counting Text Data 0
Access query not showing as sources for pivot table 2

Top