How to Sync Excel Sheet and Access Database vice-versa in MS Office 2010

[phaniakella]

Dear Experts


I would like to track my development objects status in Excel sheet. Same I would like to sync this to a tab in MS Access which contains same header as Excel. If I change anything in Excel it needs to be updated in Access. Similarly If i change anything in MS Access it should be updated in Excel sheet.


Eg.


Excel Sheet


Obj_ID,Obj_Name,Start_Date,End_Date,Dev_Status
1,Interface,1/1/2013,10/1/2013,In Progress
2,Report,11/1/2013,20/1/2013,ICompleted
3,Interface,15/1/2013,30/1/2013,In Testing


MS Access DB Table: Dev_Tracker




Obj_ID,Obj_Name,Start_Date,End_Date,Dev_Status
1,Interface,1/1/2013,10/1/2013,In Progress
2,Report,11/1/2013,20/1/2013,ICompleted
3,Interface,15/1/2013,30/1/2013,In Testing