Difference between revisions of "Driving a SQL Connection from an Excel range"
(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...") |
|||
| Line 6: | Line 6: | ||
# Click the Select Range button | # Click the Select Range button | ||
# Select the cell you typed the connection string into in step 1 | # Select the cell you typed the connection string into in step 1 | ||
| + | |||
| + | ==See Also== | ||
| + | * [[SQL Data Tables (Administrators)]] | ||
| + | * [[SQL Data Tables (Standard Users)]] | ||
| + | * [[XL3QueryTableSetConnectionString]] for a similar feature in XLCubed 6.5 and previous versions | ||
| + | |||
| + | [[Category:Relational Reporting]] | ||
Revision as of 17:14, 2 April 2014
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
See Also
- SQL Data Tables (Administrators)
- SQL Data Tables (Standard Users)
- XL3QueryTableSetConnectionString for a similar feature in XLCubed 6.5 and previous versions
