This lesson will address how to connect a Get & Transform query to other Excel workbooks, comma separated value (CSV) files, Access databases, and SQL server databases.

To complete the exercise, you'll want to download the following three files:

This exercise file contains the directions necessary for completing the exercise.

The next lesson includes a copy of the solution file as well as a video walking you through the exercise step by step.

Update: For participants using Access 2000-2003, I've included the following .mdb Access database that can be used in place of the .accdb database.