Using Excel Data to Run Access Query

[dougmcc1]

In Excel I have a sheet with about 3000 rows. Each row has an id. I need to retrieve a field from an Access database for each id in the Excel file.

I know how to query the Access database from Excel, but I don't know how to set the query to use the id's in the Excel sheet instead of an Access table.

Any help would be appreciated. Thanks.

 

[dougmcc1]

I found out how to link to Excel from Access. In Access I created a link to the Excel file. So Access is now linked to the Excel data just as it would a table from another database.

So then I tried creating the query in Excel which uses the Excel-link in Access. But in the first step of the Query Wizard when it asks for the columns to use, if I try adding the Excel link it doesn't do anything. When I click on the Excel-link and then click the arrow to add it to the field to the right, it doesn't get added.

Any ideas?