Driving 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: Dynamic SQL Connection.png
  3. Click the Select Range button
  4. Select the cell you typed the connection string into in step 1

See Also