0
Answer

new data insert from excelsheet to sqltable

Ask a question
Hi,

I have a excel sheet where data is there.

I am able to do new insertion(first time) and updation.
But I want that if new data I will add in excel and then I need to add in sql table.

ex.

I have 5 records(1-5) in my excel so first ,when I ll insert file to db, data will save in db and same update also but if I add 2 new records(6-7) in excel and then going to add in db.
then it should insert only new 2 records not 7 records.

Please help.