VBA to retrieve Data from Access for use in Excel

[CapsHockey]

I have an Excel application that I would like to be able to send data to and retrieve data from an Access database. I would like the user to be able to click a button for this feature and have it be as transparent to the user as possible. Ideas?

 

[JHSam]

This link should help ...

http://www.erlandsendata.no/english/vba/adodao/