Updating MS - Access fields through MS-Excel cells
- by SpikETidE
Hi everyone....
Consider that i have an excel workbook and an access table not necessarily having a similar structure (i.e. They may not have same number of columns)
When i open the workbook the rows in the excel sheet get populated by the rows in access table (copied from the access table into the excel sheet's particular range of cells specified using macros).
Then i modify certain cells in the excel sheet.
I also have a button called "Save" in the excel sheet. When pressed, this will execute a macro.
My question how can i update the access table to reflect the changes in the excel sheet when the save button is clicked...?
Thanks for your time and suggestions...!