AnsweredAssumed Answered

Import only new records, Ignore matching records

Question asked by aklobby on Sep 26, 2011
Latest reply on Sep 26, 2011 by AnaxThomas

Title

Import only new records, Ignore matching records

Post

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. 

Allison

Outcomes