Query an Access Database from Excel

**The VBA code used in this video can be found here:
http://accessjitsu.com/2015/09/13/cod...

We will use an Access database as our data source. We will add a button to an Excel spreadsheet to refresh the data in the spreadsheet. Then we will embed Visual Basic for Applications (VBA) in the spreadsheet that will:
1. Clear out data from previous executions of our code
2. Query our source database
3. Write the data we retrieve into our spreadsheet
4. Keep track of how many rows of data we retrieved from the database
5. Add two SUM formulas at the bottom of our data range

All of my videos organized by topic and other blog topics:
http://accessjitsu.com/

A previous video where we drove this same process from Access. We used the Excel VBA CopyFromRecordset method from our Access code:
Introduction to exporting data from Microsoft Access to Excel: Part 2
   • Introduction to exporting data from M...  

Videos in this series:
Manually Copy Data From Access to Excel
   • Manually Copy Data From Access to Excel  

Link a Spreadsheet to an Access Database
   • Link a Spreadsheet to an Access Database  

Excel VBA to Extract Data from an Access Database
   • Excel VBA to Extract Data from an Acc...