Comapre values in database with a excel-cheet

Hi!

Have an excel spreadsheet that I need to compare the values ¿¿in a table in ms sql.
All rows in excel which are not similar to that found in the database. Should be out in a new exelfil. So I left with a excelark with rows that are not equal to those available in the database.

How can I fix this?
LVL 2
team2005Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Salim FayadConnect With a Mentor Commented:
I suggest that you import the data in your excel file into a new table in MS SQL. This way, you can compare the data in the 2 tables like you want. After that you can export back the data that you need into a new excel file
0
 
team2005Author Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.