What we are going to do is to calculate the Age of a person using the birth date. Add the Age Column to the current table in Excel. You can also use filters as you do with normal data in MS Excel.įigure 14. You mainly have access to the data to create special reports that can be easily done in MS Excel. If you try to edit the data you will edit it in Excel, but the changes are not reflected in the SQL Server Azure table. Once you press OK, You will notice that the data from the employees table is now in Excel. How the SQL Server data will be displayed You can create the data in the existing worksheet or in a new one.įigure 1 1. You can import the data in a table, PivotTable Report, PivotChart and only create the connection. If you open the file with a text editor, you will notice that it is a simple file with xml format and that it can be easily edited.įigure 10. The odc file with the connectionīy default, the ODC files are stored in my documents>my data sources folder, but you can specify the path of your preference. You can specify where to store the file and specify a description, a friendly name and search keywords to search the files easily. In Excel, an odc file is created to store the connection information. You can also differenciate tables or views using the Type column.įor this example, we will use the Employee table of the AdventureWorks database, but any table with data can be used for this test. Note that the icons for tables and views are different. In this example, we will connect to a specific table.įigure 5. You can connect to a specific table/view or you can select multiple tables. In this example, we will use the AdventureWorks2014 database. Login information to SQL Azure using the SQL Authentication Paste the Azure virtual machine name with SQL Server and specify the SQL Server User name and the SQL Server Password.įigure 4. The Azure Portal, retrieving the Server name in Azure. Copy and paste the virtual machine name to be used.įigure 3. In the Azure Portal in the Virtual Machines section, verify the virtual machine name used. Go to the Data Menu and click the From Other Sources icon> From SQL Server.įigure 2. For this article, I am using Excel 2013, but the 2010 will work.
![ms excel connect to mysql ms excel connect to mysql](https://syntaxbytetutorials.com/wp-content/uploads/2020/09/mysqlinterface.png)
A SQL Server authentication enabled and a SQL login and password.
#Ms excel connect to mysql windows
A local machine with Windows installed.
![ms excel connect to mysql ms excel connect to mysql](https://www.w3resource.com/w3r_images/excel13.png)
A VM Machine in Azure with SQL Server already installed (check my article about Azure VMs).I am assuming that you already have a VM in Azure installed.
#Ms excel connect to mysql how to
In this chapter, we will show how to connect to SQL Azure using Microsoft Excel. That way, the end user will be able to easily create reports, charts and generate useful information. That is why it is recommended to connect our SQL Azure database to Excel. Most of the end users have a good knowledge in MS Excel. However, as a Database Developers and Administrators we need to help the end user to access to the information using a familiar and intuitive interface. There are great Microsoft tools to access to SQL Server in Azure.