Microsoft Office Tutorials and References
In Depth Information
Passing Your Own SQL Statements to External Databases
Description: In the Description field, you can enter a plain description of what this
particular data connection does.
Friendly Name: The Friendly Name field allows you to specify your own name for the
external source. You typically enter a name that is descriptive and easy to read.
6. When you are satisfied with your descriptive edits, click Finish to finalize your connection
You immediately see the Import Data dialog box where you can choose how to import your
data. As you can see in Figure 18-13, this data will be shown in a pivot table.
Figure 18-13: Choosing how and where to view your SQL Server data.
When the connection is finalized, we can start building our pivot table.
Passing Your Own SQL Statements
to External Databases
If you’re proficient at writing your own SQL queries, you can use the connection properties to write
your own SQL statements. This gives you more control over the data you pull into your Excel model
and allows you to perform advanced actions like running SQL Server stored procedures.
Manually editing SQL statements
After you’re connected to your external database, you can go to the Data tab on the Ribbon and
select Connections. This activates the Workbook Connections dialog box illustrated in Figure 18-14.
Choose the connection you want to edit and then click the Properties button.