Search
Submit & Win
Submit and win
Prizes !
Winners

Win Prizes

Social Presence
Twitter Twitter LinkedIn YouTube Google

Like us on Facebook
Advertisements
Top Forums Author
Thu, 18-Dec-2014 Authors
Naveenrohillamca
10
Shoyebaziz123
10
All Time Authors
Jayakumars
4210
Karthikanbarasan
3455
Shanky11
3150

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 : 1585 | 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] Diamond | 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


Share this to:

Bookmark It