| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking a table in Access to a table in Excel using MS Query
In MS Query I would like to connect a Table from Access with Vendor Names to a small table in Excel specifing one Vendor Name and thus filtering the results
When I try to add a new table in MS Query I only have an option to add tables from the access database...Is it possible to connect those two tables Thank you for your help Dian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Linking a table in Access to a table in Excel using MS Query
AFAIK, you can't connect an Access table and an Excel table in MS Query.
In Access, you could link to the Excel table, then connect the tables in an Access query. From MS Query, use the Access query as a data source. Diana wrote: In MS Query I would like to connect a Table from Access with Vendor Names to a small table in Excel specifing one Vendor Name and thus filtering the results. When I try to add a new table in MS Query I only have an option to add tables from the access database...Is it possible to connect those two tables? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Connection of Excel 07 pivot table to Access Query makes DB read o | Excel Discussion (Misc queries) | |||
| HELP linking access table to excel | Excel Worksheet Functions | |||
| 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) | |||
| Linking Large Access Table into Excel | Links and Linking in Excel | |||
![Diana[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
