samedi 28 mars 2015

How to to import Excel into SQL Server without duplicates?

I have to upload Excel data into SQL Server. That data how to check and insert into previous table.


For example, previous table:



id name address
1 mohan chennai
2 raja madurai


Excel data



id name address
1 ram covai
2 mohan chennai


In this case I should only update ram into previous table, because mohan is already available in database table.


Aucun commentaire:

Enregistrer un commentaire