External Data

This video demonstrates how to automatically import data from a Microsoft Access database using Excel's External Data Range feature.  This is a powerful technique to pull data into Excel, and is extremely important when automating recurring processes.