I can import data from Access to Excel then calculate table entries but I can't export back to Access using VBA.
After I start an instance of Access from Excel's VBA I don't know which methods to use to "Get External Data" and add it to the original table I found it in. I would like all the code to be started from a click of a button on an Excel spreadsheet.
Can anyone point me in the right direction. The best case would be to update the fields which have changed. At the very least I would like to be able to overwrite the original table with the transformed table.
I am using Excel because it is a program that others in my office are comfortable using.
Thanks.
After I start an instance of Access from Excel's VBA I don't know which methods to use to "Get External Data" and add it to the original table I found it in. I would like all the code to be started from a click of a button on an Excel spreadsheet.
Can anyone point me in the right direction. The best case would be to update the fields which have changed. At the very least I would like to be able to overwrite the original table with the transformed table.
I am using Excel because it is a program that others in my office are comfortable using.
Thanks.