How to Create an Excel Connection to a SQL Database

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

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

data from sql server

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

user name password

Note: Keep following the instructions, until you finished.


You can download the Template here – Download
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial