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?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.