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