Probably easy to do but.....

[RaptorZ]

I have a list in Xcel of approximately 1100 client #'s that I have to match to our master list of 10000's.

I can create a query to pull these Clients, but I'd like it to only pull the 1100 requested. Is there a way to import an excel file to bump up against a query so that it only pulls the requested clients?

IE do I have to create a table and bring that data in then use them both in the query?

Sorry if this is a simple question, I'm just being thrown into the fire and have very little access background.

 

[Pat Hartman]

You can import to or link the spreadsheet. If you need to update the resulting recordset, you'll need to import rather than link. Then create a query that joins the big table to the imported table. Draw a join line to connect the two tables by the unique identifier and choose the fields you want from each table. The query will return only records that exist in BOTH tables.