Bagesh kumar singh

Bagesh kumar singh

  • NA
  • 65
  • 104.1k

Comparing Excel Sheet data with SQL Table?

Dec 24 2013 5:18 AM

I have one database in sql server in that i have one table known as master table in that i have master data. My problem is my master data has been change frequently(i mean my client give the master data in excel sheet old + new data) it is defucult to find which one is new data. so i want to design one page where we can upload the excel file and we can we can Compare Excel Sheet data with SQL Table and new data will be inserted on database.so how can i will do this. Please give some idea.

Thanks in Advance.


Answers (1)

-2
Nimit Joshi

Nimit Joshi

  • 0
  • 26.9k
  • 14.5m
Dec 24 2013 6:57 AM
Hi Bagesh,

Following is the link in which it is described that how to connect the Excel file to ASP.NET Web Application:

http://www.c-sharpcorner.com/Forums/Thread/241307/comparing-excel-sheet-data-with-sql-table.aspx

Hope this helps you to connect the excel file and upload it.