Excel VBA to Extract Data from an Access Database

Query an Access Database from Excel

**The VBA code used in this video can be found here:
http://accessjitsu.com/2015/09/13/code-listing-excel-vba-to-extract-data-from-an-access-database/

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
https://youtu.be/6s5jY09KZT8

Videos in this series:
Manually Copy Data From Access to Excel
https://youtu.be/zQqZ45DT1WA

Link a Spreadsheet to an Access Database
https://youtu.be/yu56ZuR-bXY

Excel VBA to Extract Data from an Access Database
https://youtu.be/lF8WMKzLlac

Видео Excel VBA to Extract Data from an Access Database канала Access Jitsu