Upload Data from ExcelSheet to Sql Database

First insert all records from sheet to Database temporary table at single shot to avoid performance issue. Follow below links:

 

http://www.c-sharpcorner.com/UploadFile/99bb20/import-excel-data-to-sql-server-in-Asp-Net/

 

http://www.c-sharpcorner.com/blogs/bulk-copy-in-sql-server-using-c-sharpnet1

 

Then write a SP(Stored procedure) and implement whole logic here. In SP loop over all records in temp table and check whether record exits in your table. If it is not present then insert record to original table otherwise update record in original table.

Dear Chandu Kumawat,

 

 in this is reference link we(developer) can do it manually at one time but my requirement is that on client(user) side it is not possible to do that way so below I explain issue in brief:

 

  In web application one country page in this one functionality is one fileupload control and one button as 'upload country' , when button click then upload country name from Excel-Sheet to Sql Database Table as 'CountryMaster'.

initially 10 country name in Excel-Sheet and upload it to Database after that user add more 5 country name to Excel-Sheet then total country name is 15 and also he changes 1st country name in Excel-Sheet then after he again perform button click and upload country name from Excel-Sheet to Sql Db but in Sql DB already 10 country name exists and these 15 country name also inserted so total country name in Sql Db CountryMaster is 25 But I want to that only last 5 record can be inserting and 1st record can be updating.

 

 So how can I achieve this if, you have solution then help me

refer this...

 

http://stackoverflow.com/questions/3474137/how-to-export-data-from-excel-spreadsheet-to-sql-server-2008-table

 

 

http://searchsqlserver.techtarget.com/feature/The-SQL-Server-Import-and-Export-Wizard-how-to-guide