Linking a table in Access to a table in Excel using MS Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

How to export table from outlook into ms access table? 0
Access Sorting and grouping using multiple tables 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA - retrieve data on last create named range from previous inserted named range 0
Link, drop link, relink 2
Refresh an Access Query using VBA code in Excel 6
help to understand 'querytable' 1
Access #Error & Excel Pivot 0

Back
Top