CSV import in SQL - Add new updated existing

Question

Is there a way to use the existing Import features from SQL Server Manager, to import a CSV file and if the record (by primary key)exists update record and if it doesnt exist then insert or do i have to write custom scripts to do this?

Import means inserting things. Updating existing data isn't importing. If you want to update existing data, import the new data into a staging table and update the production table with them — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Apr 28, 2017 at 14:02

Tab Alleman · Accepted Answer · 2017-04-28 13:58:51Z

1

You will have to write something custom for this. The import wizard cannot do this.

answered Apr 28, 2017 at 13:58

Tab Alleman

31.8k7 gold badges41 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CSV import in SQL - Add new updated existing

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related