Posted on: 9/20/2012 1:56:54 PM | Views : 284

I have Excel sheet and have 1000 records are there, i want to verify duplicate id and name, before insertin in SQL Table, Please Help me.
If the record exists, then i will move to the next record and then insert.
Excel column ------------ Emp_Id   Emp_Name
Table Column ------------- Emp_ID Emp_Name
Emp_Id Should check the duplication from the excel and then insert. if duplication founds then it should check and insert the next rows.
How to do this..?
Excel column ------------ Emp_Id   Emp_Name
Table Column ------------- Emp_ID Emp_Name
Emp_Id Should check the duplication from the excel and then insert. if duplication founds then it should check and insert the next rows.
How to do this..?
...

Go to the complete details ...