These options later because you may want to opt for one over the other.Ĭlick Next and Excel will search for the server name we typed on the network (or Username and password combination to connect to the database. Windows Authentication willīe fine for this example, however, at work you may need to use SQL Server In (local) (and yes, do keep the parentheses). Normally, I would put some kind of URL there, but I’m writing thisīlog from home and I’ll be using SQL Server on my local machine.
The Data Connection Wizard will pop up and request info about which server you Start with grabbing the external data from SQL Server. Now it’s time to put that query inside a pivot table. While the post is about 2012, I installed my database on 2008 which is why I needed the 2008 data file in the link above.
In order to install a downloaded database in an mdf file format, please see Pinal Dave’s blog post here.If you need a sample database, or would like to follow my example, I downloaded the AdventureWorks2008R2 database file found here.Some database to connect to (whether it’s local or on a server). Knowledge of SSMS and basic SQL queries.Management Studio (SSMS), test out the query, and then put the query inside anĮxcel pivot table in order to display the data. Instead, I usuallyĬreate a custom SQL query to one of our SQL Server databases using SQL Server Worksheet data like in most examples you’ll find online. And there aren’t many days that I don’tĬreate/use/manipulate pivot tables in some way. Subscribe About Terms Excel - Create a Pivot Table Using SQL