originally i had the import as taking each workbook and making each sheet a separate file and then importing the 10 sheets into the table. but there was a bit of overhead with that so i wanted to dumb it down into less steps and make that as automated as possible.

In the other project the transferspreadsheet method is used for the import. There are primary keys defined in each table and relationships based on those keys. Then there are join queries that run to generate the duplicates. There are reports based on those queries that display the results of the query. Then there is a delete button to clear all tables that is protected by a password.

So really all i need to redo is the import step, everything else is already in place.