im doing a DB insertion from a excel sheet i need to check the row that are in excel but not in DB and add those row to db as well.
Does your Excel and DB have an unique column like DocNo or EmpNo?
their no one unique column
Can you share a screenshot of your Excel, if possible?
Alright, in this case, you can iterate through the Excel DT using For Each Row, get the required row and check if this exists in the DB DT and in the else condition, you can add it to the DB DT using Add Data Row.