Comparing Excel Sheet data with SQL Table

_{Tuesday, January 29, 2013 7:18 AM}

Hi

whether it is possible to compare the excel sheet data with the sql table ?

any c# code or tool developed in c# is available?

- Ram

_{Tuesday, January 29, 2013 7:22 AM ✅Answered}

Here is a link that may be helpful to you:

How to use Excel with SQL Server linked servers and distributed queries

Krishnakumar S

_{Tuesday, January 29, 2013 7:56 AM ✅Answered}

Hi Ram,

 Import the excel sheet into database  and create it as table and then you can do a compare data between two tables .

To import the excel sheet into database ,right - click on your database - > Tasks - > Import Data ...

Thanks & Regards, sathya

_{Tuesday, January 29, 2013 7:30 AM}

Ram

If you wanted to do that visa C# then you will be better of asking that question on C#forum

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance