how to upload excel file if data exit not to inset that row

Question

how to upload excel file if data exit not to inset that row ?

 

hi , i want to upload excel file into database using asp.net C# ?

 

If row already exits then not to inset that row into table ?

 

Please help me to this question ? 

Answer 1

Hi

check the link

 

https://msdn.microsoft.com/en-us/library/ms187550.aspx

 

 

http://stackoverflow.com/questions/37523850/how-can-we-validate-duplicate-in-database-table-while-inserting-data-from-excel

Answer 2

Hi Ajit,

I am sharing a link check it,if not resolve your issue ,post your code whatever you have tried .

http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/?