Microsoft Office Tutorials and References
In Depth Information
Importing Data from SQL Server
Start on the Data tab and follow these steps:
1. Select From Other Sources to see the drop-down menu shown Figure 18-9; then select From
Figure 18-9: Select From SQL Server from the drop-down menu.
Selecting this option activates the Data Connection Wizard, as shown in Figure 18-10. The
idea here is that you configure your connection settings so Excel can establish a link to the
2. Provide Excel with some authentication information.
As you can see in Figure 18-10, you enter the name of your server as well as your username
and password. If you’re typically authenticated via Windows authentication, you simply
select the Use Windows Authentication option.
Figure 18-10: Enter your authentication information and click Next.
3. Select the database with which you’re working from a drop-down menu containing all
available databases on the specified server.
As you can see in Figure 18-11, a database called AdventureWorks2012 is selected in the
drop-down box. Selecting this database causes all the tables and views in it be shown in the
list of objects below the drop-down menu.