title: Query patient ID #s from an Excel 2007 list?
body: <p>I'm using an Access Database that is designed relationally.  I have a list of patient IDs in an Excel spreadsheet that I imported and made into a table in Access named importedPatients.  There is a related table named Counties that is a one to many relationship for the main Patients table.  How can I use the patientIDs present in the importedPatients table to quickly query out information in the related Counties table?  Is there an idiomatic way to tackle this?</p>