Search
Winners

Win Prizes

Social Presence
Twitter Twitter LinkedIn YouTube Google

Like us on Facebook
Advertisements
Top Forums Author
Tue, 02-Sep-2014 Authors
Balotelo
10
Klbaiju
10
Mandlaa
10
All Time Authors
Jayakumars
4160
Karthikanbarasan
3455
Chvrsri
3140

Latest members | More ...


(Statistics delayed by 5 minutes)
 Forum Post

How we can Compare Excel Sheet data with SQL Table?

Bageshkumarbagi
Posted by Bageshkumarbagi under C# on 12/24/2013 5:08:59 AM | Points: 10 | Views : 1143 | Status : [Member] | Replies : 3


Hi,

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.

Thanks,
Bagesh Kumar Singh
Mark as answer if you have been satisfied


Posted by: Vishal@Neeraj on: 12/24/2013 [Member] Gold | Points: 25

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=146241
http://davidchuprogramming.blogspot.in/2010/11/using-excel-to-compare-sql-database.html

Bageshkumarbagi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Allemahesh on: 12/24/2013 [Member] Silver | Points: 25

Below link will help to solve your problem:-

http://support.microsoft.com/kb/306397?wa=wsignin1.0

Bageshkumarbagi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vermdivya on: 12/24/2013 [Member] Starter | Points: 25

Import excel sheet file into SQL Server table and then compare them using SQL Query.

The best way to solve your problem is rather than comparing tables, delete all the old rows of master table and then insert new rows (with Identity update) that way you are 100% sure everything is correct.

Bageshkumarbagi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response


Found interesting? Add this to: