View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Diana[_5_] Diana[_5_] is offline
external usenet poster
 
Posts: 24
Default 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