Level of Experience: Intermediate

I would like to build a query that can read a list of IDs (numeric) and pull the respective information from the database.  However, my list of IDs vary each time and can range from 1 to 100s of records.  Is there a way to get the query to read the list of IDs line by line from say an Excel spreadsheet, instead of typing each ID under Criteria?  Thanks.

---

Answer from Richard Rost:

If you have the data in Excel already, just IMPORT it into an Access table. Then you could use a query to match it up to whatever other data you have in your database.