| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiple MS Access table sources for pivot table
Hi
I would like my pivot table to draw data from several tables in an Access database. Although I have gone through the query wizard and added the fields from all the database tables, I still find that when Excel reads the data into the pivot table it stops after the first table and I only get part of the source data I am looking for. What am I missing in order to consolidate the data from several tables? with thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
| Excel Pivot Table with Access | Excel Discussion (Misc queries) | |||
| How can I update an MS Access table record from within Execl works | Excel Discussion (Misc queries) | |||
| copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
| HELP: Access table linked to Excel - calculated fields? | Excel Worksheet Functions | |||
Threaded Mode
