I have been creating a database that keeps track of the number of tools in our shop. To keep the upkeep of this database simple, I have created buttons that will import all the relevent data from Excel sheets they alreay use.

With this button, I move through each record in the excel sheet, coping it to a new table (I call that 'tempImport'), which is then used to update the main tool inventory table. The 'tempImport' table that I use...