Only Update Specified Columns with CSV Import

[TJStephens]

Currently, if I import a CSV file to update a row it removes data from any column in the row that is not in the imported CSV. I would like to be able import a CSV and only have it update the columns that are in the CSV that is uploaded. For example, if have any table of orders with a Key field and a lot of different columns in the table, I would like to be able to import a CSV that just has the Key field column and the tracking number column and have the tracking number column update without it deleting the information from the other columns.

[Steve]

As a workaround, consider creating a new table to receive the import, then use a bot to migrate the imported data to the live table.

[TJStephens]

Thanks Steve. I’ll give that a try.