Query Assistance

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

Guest

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.
 
Each record in table has a unique identifying number I need to select approx. 250 of these records by their
individual id number.
Click to expand...
Is there a chance that these numbers have a unique set of characters in the strings of the ID numbers? If they have anything in common at all that makes them stand out from the rest, you could use the LIKE operator.

I have identified the actual record ID's I need and they are in a separate excel .xls
Click to expand...
Could you simply import these records if you need them in Access?
 
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.
 
Back
Top