Updating records from the Excel Spreadsheet
I have data with some 4,000 records, which I imported on QuickBase and created two tables sharing the parent-child relationship from one spreadsheet. The spreadsheet has several entries with the same ID, so there is no unique identifier for each record in the spreadsheet. On QuickBase, I have established a parent-child relationship. Hence, the parent table has a unique identifier, and the child has multiple records of a single ID in the parent record. The data gets updated every month, and there is a new spreadsheet every month that will have some updates in the existing data records and some new forms.
Can I find new records and updates in the existing records in the spreadsheet and import the updated data into two different tables that I have on QuickBase?
------------------------------
Chaitali Damani
------------------------------