Import Excel into multiple tables

[hpl2001]

I'm working on a project to create an access app that will replace the manual management of over 100 spreadsheets. In my design for the database I want to have three tables, 2 data and one lookup. I have never attempted an import of this kind before, so I'm looking for advice on how best to import a number of excel spreadsheets (same layout) and have the data end up across the three tables.

TIA. Holly

 

[dhookom]

I typically import the spreadsheets into a temporary table and then have queries (typically append) that handle pushing the records into the permanent tables.

Duane
Hook'D on Access
MS Access MVP

 

[randy700]

Also, remember to include a delete query to remove the data from the temp table before your next import.

Randy