| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access query not showing as sources for pivot table
Hi,
I have Access 2003 and Excel 2007. I have successfully linked several access queries to excel pivot tables. However, there is a select query in access which does not show up in the list of queries to choose from. I cannot figure out why. The query links a query to a table and runs successfully in access. It doesn't have an parameters or anything like that. Are there reasons that anyone knows of as to why a select query would not appear as a data source for a pivot table? Thanks, Chuck |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the Access query a pivot table is based on | Excel Discussion (Misc queries) | |||
| Excel Pivot Table or Access Cross Tab Query Question | Excel Discussion (Misc queries) | |||
| Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
| Pivot table - multiple sources | Excel Discussion (Misc queries) | |||
| Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
![Chuck W[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
