rachayita jaiswal

rachayita jaiswal

  • NA
  • 32
  • 11.2k

excel data with sql table

Aug 23 2014 3:29 AM
Hi,

 I have a excel sheet with 2 records where one field is Status = "Active".

excelshseet:
 idname  age status
 1name1  age1 Active
 2 name2         age2         Active


I am storing it in database
now next time when again I am going to update data then my excel sheet is -

excelshseet:
 idname  age status
 1name1  age1 Active

              


then in database for id(2) status should become "Inactive".

data base table:
 idname  age status
 1name1  age1 Active
 2 name2         age2         Inactive


Please help.

Answers (4)