How to use data from Excel file for criteria in an Access selection query?

[General Ledger]

Dear All,

I won't ask if it is possible because there is always a way. How do I use values from an Excel 2003 file to supply criteria to an Access 2003 selection query?

I have a query that returns all the open accounts payable transactions. I want the query to only return records for certain vendor ID numbers. I have a list of the vendor ID numbers in Excel. How do I tell Access to run the selection query and return the records only for the vendor ID numbers listed in an Excel file? The ID numbers are subject to change, are not sorted in any particular order, and the count of ID numbers may change.

Thanks to all,

GL

 

[Kreszch68]

First link the Excel file to your database, then in a query join the vendor ID to the corresponding field in the Access table.