Query table using criteria from an Excel document

[jonh]

Hello,

I have a Access table of names and addresses. There is a postcode (zipcode)
text field. I also have an excel spreadsheet with a single column of
postcodes; no duplicates.

I need to get query to return each name and address in the table which has a
postcode listed in the spreadsheet.

Typing each postcode manually into the query seems clumsy.

Any ideas?

 

[Jeff Boyce]

Add a link to the Excel data.

Create a new query joining the linked Excel data and your Access table on
the postcode field.

Those that match will result.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[jonh]

Great, this worked fine. Thank you very very much Jeff.