How can I use the Excel VBA to control the functions of Mixrosoft Access?
I want to first copy the data to the Access Database, and then a the data will be proceed in Access.
After proceeding, the data will be sent from Access to Excel this time.
Can I do them by Excel VBA? Thanks you!