Quote Originally Posted by mpearce
the only thing with dropping the primary key is that with each click of the button more records are appended to the end of the table.

so my understanding is that the primary key would stop that from happening. So that if an import is already done and the import is run again access will realize that these records already exist and wont import them again.
I wondered about that. Sounds like we should throw away all records from those 10 Access tables before importing from Excel. That's easy to automate. Let me know if that's not what you want.

Hans