SqlBulkCopy Update Existing Rows using C# .Net

Last Reply on Aug 19, 2014 01:17 AM By Mudassar

Posted on Aug 18, 2014 06:27 AM

This is related to the below link

http://aspsnippets.com/Articles/Using-SqlBulkCopy-to-import-Excel-SpreadSheet-data-into-SQL-Server-in-ASPNet-using-C-and-VBNet.aspx

Instead of inserting the data from excel, I want to update the SQL table using Excel file.

For Ex: If I have SQL table like this

ID  Name  Salary

3   XYZ     40000

Is it possible to update the SQL table using Excel data.

Using Update query, Where ID =3 like this