Import only new records, Ignore matching records
I am trying to update my filemaker database with data from an excel spreadsheet. There are about 9000 records in the existing database and about 9100 in the spreadsheet. I want to be able to add the new 100 records, leaving alone the 9000 existing records. I do not want to waste time looking through the spreadsheet to identify the 100 new records. Is there a way I can only add the new records? Each time I try adding the new records by chooding add new records in the import function, I get all 9100 added to the database.
Any help would be greatly appreciated.