Member Avatar for mca.shantha

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.

  • 2 Contributors
  • 1 Reply
  • 78 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by thines01
Member Avatar for thines01

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.