5 Replies Latest reply on Sep 26, 2011 11:41 AM by AnaxThomas

    Import only new records, Ignore matching records

    aklobby

      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