Updating Records in a Form from Excel
Hi:
We need to update existing records in Creator from records in an Excel spreadsheet. We see how to do this using the Migration tool, but the problem is, we are on a Mac. Is there another way to accomplish this?
As presented from another post, here's the functionality we're looking for:
1. If the keys match, we would like to update/overwrite all the fields in the corresponding record using the Excel sheet data.
2. If the keys don't match, we would like it to create a new record and populate it with the fields in the Excel sheet.