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.