How to to Connect to SQL Server with Microsoft Excel

There is a way to connect to SQL Server with Microsoft Excel. This will be done in a step-by-step format.

Get data

Click Data (1), From Other Sources (2), and then From SQL Server (3).

data from sql server

Connect do data base

Write the Server name that is the same as it is in your domain and hosting supplier (1), choose Use the following User Name and Password (2), write your login information (3), and press next (4).

SQL Server user name password

Note: Keep following the instructions, until you finished.

Further reading: 
Import external data from text files
Database Functions
How to use SQL in Excel
How to Convert Excel to Web Database?
How to run SQL in Excel VBA