Hi,
I have a excel sheet with 2 records where one field is Status = "Active".
excelshseet:
| id | name | age | status |
| 1 | name1 | 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:
| id | name | age | status |
| 1 | name1 | age1 | Active |
| | |
|
then in database for id(2) status should become "Inactive".
data base table:
| id | name | age | status |
| 1 | name1 | age1 | Active |
| 2 | name2 | age2 | Inactive |
Please help.