2 Replies Latest reply on Apr 4, 2010 8:56 PM by pault

    How to import excel  data in this case?

    funfun167

      Title

      How to import excel  data in this case?

      Post

      Suppose an excel file is created by my shopping cart every day, the file contains order details on that day.

       

      The excel file contains 3 fields, namely

      1: order number

      2: first name

      3: last name

       

      I will upload the excel file every morning

      When the file is imported to filemaker, it is expected to do the following:

      1: if the order number in the excel files exists in one of the existing filemaker record, filemaker will UPDATE that record

      2: if the order number in the excel files doesn’t exist in any filemaker record, a new record is CREATED

       

      May I know how I can do this?

       

      Thank you

       

       ---------------------------------------------------------------------

      Right now, when I import the excel file by: File---Imports Records----File

      The records in that excel file are imported into filemaker while the old records are deleted…..this is not what I want…