I currently have a database in Access with 5 fields (company name[primary key], phone, fax, email, POC). On a monthly basis I need to import 50+ excel sheets of company names with no information and use a select query to fill in what i have from my database.

I end up using query design 50 times to make the same connection of company name as the primary key between the database and the imported table, selecting (importedtable.field 1, database.phone, database.fax, database.email, database.poc)

I would like to know if anyone can think of a way to use this same design on multiple imported tables without combining them.