When you link a excel sheet to Access database you can access all the info from that excel sheet in Access but you cannot edit or add data in the table that is linked to excel.
In order to do this you will have to either:
1 - Create a module which will update the excel file manually field by field. This will be a more time consuming option and will thus cost you more. On the other hand this method will help you preserve the formatting and formula present in your excel sheet.
2 - the second option is to import all the data in to Access and whenever you need you can export all the data in the table to an new excel sheet. This will be easier to program and thus will be cheaper. However the new excel will not have any formatting.
I can adopt any of these approaches - it depends on what you want.
If you can send me the excel - I will give you a firm quote for time and cost required for either of these options.
Rajiv
PS: I am a vaishnav myself and would thus be interested in doing this for you at an optimal cost..
UK-based Access Developer for 15+ years, I can do what you need without any problems. Please contact me if you would like further information - thanks.
I am experienced software developer.I can give you best quality application as per your requirements.I have gone through your requirements ,I assure the project to be completed on time with good Quality. looking forward to work with you! .....Thanks!!
