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:
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 ...