Drive a SQL Connection from an Excel range

The relational connection used by Tables and other objects can be driven from a range.

To do this, when creating the connection:

1. Type a valid connection string into an Excel cell. For example: Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=AdventureWorksDW;Trusted_Connection=Yes
2. Select the Custom OLEDB Connection option from the connection type dropdown.
3. Select the Select Range button.
4. Select the cell you typed the connection string into in step 1.