How To Connect Excel To Azure SQL Database And How To Work On It

In this article, you will learn how to connect Excel to an Azure SQL Database by using Azure Portal, and how to work on it.

Prerequisites

  • Azure account.
  • MS-EXCEL

Now, let's get started with the following steps.

First, we connect Excel to Azure SQL database. So, open the Excel and create a Blank workbook (or open an existing one).

Excel

In the menu bar, at the top of the page, click Data >> From Other Sources >> From SQL Server.

Data

In the Connect to Database Server dialog box, type the Azure SQL Database Server name that you want to connect to, in the form <servername>.database.windows.net. (Server name get from Azure Portal).

Connect

Next, under Log on credentials, click "Use the following User Name and Password", type the User Name and Password you set up for the SQL Database server when you created it, and click Next.

credentials

In the Select Database and Table dialog, select the database that you want to work with, from the list. Then, click the tables or views you want to work with and click Next.

Database

Finally, the Save Data Connection File and Finish dialog box opens. Here, we provide the information about Office database connection (*.odc) file that Excel uses. We can leave the defaults or customize your selections.

Save Data Connection File