Driving a SQL Connection from an Excel range
Revision as of 17:12, 2 April 2014 by Antonio.remedios (talk | contribs) (Created page with "The relational connection used by Tables and other objects can be driven from a range. To do this, when creating the connection: # Type a valid connection string into an Exce...")
The relational connection used by Tables and other objects can be driven from a range.
To do this, when creating the connection:
- Type a valid connection string into an Excel cell, for example:
Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=AdventureWorksDW;Trusted_Connection=Yes - Select the Custom OLEDB Connection option from the connection type dropdown:
- Click the Select Range button
- Select the cell you typed the connection string into in step 1
