Hi Colin

Is there a product ID or something unique in each record? If so, index the view on that unique ID. You could use that index to update the view with data from the csv. Select the matching records from the CSV, update the view. Then select the unmatching records from the csv, append them into the view. You might even want to delete records from the view that are not in the csv. Then after all of that issue a single tableupdate.

That should result in the table matching the csv. If you need to reduce the number of updates, you could check if something in the csv is different from the view.

select * from csv where csv.ID = view.ID and (csv.price <> view.price OR csv.description <> view.description)

HTH