Query Assistance

[morehead]

I have a table with approx. 400000 entries. Each record in table has a unique
identifying number I need to select approx. 250 of these records by their
individual id number. I have identified the actual record ID's I need and
they are in a separate excel .xls. How can I write a single select query to
select these 250 records based upon there individual ID number. the records
are not in sequence but are scattered throughout the table.

If this can be accomplished by an expression please explain and describe.

 

[David Cox]

I would import the Excel file into Access as a table. You just add this
table and your large table to the design grid and link them by the id. Job
Done.

 

[raywood]

thanks...i linked to the table and performed a select query this worked.