How can I use the Excel VBA to control the functions of Mixrosoft Access?

I want to use VB to make a interface in Excel, that one can click a button to call functions in Excel and also in 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... show more I want to use VB to make a interface in Excel, that one can click a button to call functions in Excel and also in 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!
Update: Thanks!But I know nothing about COM. Is it difficult to write? Or can I still complete the interface function without using COM?
2 answers 2