Updating table from spreadsheet only if unique value for name (1 Viewer)

[The Rev]

Good day. I have a table in Access called Tbl_Interviewee and a spreadsheet that I give to my interviewers to have locally for job fairs. It's a simple 2 column table with fields named Int_Name and Int_Ptn. I want to be able to use an import button with VBA script to import the spreadsheets into my database and only import unique values so one person doesnt interview multiple times for the same position with multiple intwrviewers. What's the best way to do that? Looping through the spreadsheet rows and comparing them to the table entries seems too cumbersome.

TIA.

 

[arnelgp]

create compound index on the two fields (no duplicate) and carry the normal append query.