I have a table with a large dataset, with 5 columns which data can change (the first is a unique ID that doesn't change). I am given the same dataset in CSV that I can then import as a linked table which may have changes
What Im trying to do is loop through the existing dataset and update those records where the data has been updated in the CSV.
Also, the CSV may contain new records.
The data is too big to just delete and re-append
What Im trying to do is loop through the existing dataset and update those records where the data has been updated in the CSV.
Also, the CSV may contain new records.
The data is too big to just delete and re-append