Hi,

I am maintaining 100 lakhs record in 1 table often i browse 1 excel from my desktop and import excel into sqlserver.In which there is possibility of same data in that excel that data should be updated in sqlserver and in excel sheet there is possibilty of new data and that data should be inserted into sqlserver using bulk import excel into sqlserver using c# window application.How to perform this.


Thanks.

If I understand your question correctly:
You want to insert new records and update existing records in SQL Server based on the content of a spreadsheet. Then you want to export that entire database back into a spreadsheet.

Is that correct?

If so, are you familiar with programming either side of this problem?
Meaning: Are you comfortable with updating SQL Server or Updating an excel spreadsheet programatically?