if Exists update else insert into database from excel

Question

User-913680646 posted

Hi,

I am working in a asp.net project. Now I need how to read the data from excel file and if Exists update else insert into database table using asp.net c#.

Please any one help me....

Thanks....

Answer 1

User-219423983 posted

Hi karthik2015,<!--?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" /--><o:p></o:p>

You could refer to the following threads which provide you some complete demo to read “.xls” or “.xlsx” files.  Especially the first one provides you a very detailed function to get excel data to DataTable and you could use it directly.<o:p></o:p>

http://forums.asp.net/t/2050500.aspx?reading+an+excel+file+in+C <o:p></o:p>

http://www.codeproject.com/Tips/705470/Read-and-Write-Excel-Documents-Using-OLEDB<o:p></o:p>

I hope it’s useful to you.<o:p></o:p>

Best Regard,<o:p></o:p>

Weibo Zhang<o:p></o:p>