rachayita jaiswal

rachayita jaiswal

  • NA
  • 32
  • 11.9k

new data insert from excelsheet to sqltable

Aug 21 2014 5:13 AM
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.