Connecting Excel to a SQL Server Table

Let's go ahead and fire up MS Excel 2016 on our local machine. Select Blank workbook, as seen in the following screenshot:

Connecting Excel to a SQL Server Table

The next step is to click on the Data tab and select New Query and From Database. Then select From SQL Server Database, as seen in the following screenshot:

Connecting Excel to a SQL Server Table

Tip

In cases where there is more than one database in the same SQL Server environment, the user will need to specify which database to use (AdventureWorks2014 in our case).

There will be a prompt for server name credentials from your ...

Get Practical Business Intelligence now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.