Importing Data From Four Separate Excel Files
I am trying to import data from four separate Excel spreadsheets in a new FMP 12 Database I created. There is a distinct value that is shared in all four databases most of the time called Record Number. I say "most of the time" because these Excel Spreadsheets do not exactly match, some have more rows or Record Numbers than others (by thousands), so it not easy to match all of them into one Excel file then do an easy import into my database. I did create a field called Record Number in my new database. Can I import these spreadsheets one by one and set the FMP database to understand that if it sees a duplicate Record Number it should not see it as a new record and to only update the other fields associated with that Record Number.
Any help would be greatly appreciated. Thanks.