http://www.onlinepclearning.com
In this tutorial we will look at the six points below. I will be demonstrating a basic way of exporting and importing data from an access database both from the spreadsheet and a userform.
1. Sending data (Exporting) to Access with ADODB
2. Importing data from Access to Excel with ADODB
3. Sending data (Exporting) to Access with ADODB from a Userform
4. Importing data from Access to Excel with ADODB from a Userform
5. What is ADO and how to enable it
6. When you might use this