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:
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:
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
