I am importing data from an Excel spreadsheet to a table and overwriting the same table each time the data is imported. I have another table, with identical structure, field names etc., that I want to transfer the new imported data to, however, I want to check if the record already exists in the second table before adding the data to the table. Right now, I can open both tables, select one or multiple rows from the first table, copy the record(s), then click on the next empty row in the second table and paste all the records. Everything works fine. But I want to perfom this checking, copying, and pasting through VBA. Any suggestions?