Export data from SQL database into Microsoft Excel 2016

Hi all

This post is in continuation of previous post where sensor data is stored in SQL database over Microsoft Azure. Sometimes, we want to process our data offline for which we may need to fetch the data from SQL server and store in Excel or CSV format. So, in that situation, we need to export data stored in SQL database into Microsoft Excel 2016 format for offline processing. 

Here are the steps to do it:

·       Open New Excel Sheet

·       Click on Data Header, Get Data—From Database—From SQL server database

·       It will ask from SQL server address. This address is available in Microsoft Azure portal, in sql database—overview—server name. For my project, address is: azuredisonsqlserver.database.windows.net

·       For the first time, it may give error for connection. You have to allow it in Azure firewall.

·       In Sql database—overview option, Click on Set Server Firewall option—Click Add Client IP. Make sure that Microsoft Azure and Microsoft Excel is on same network.

·       Now try to open SQL database in Microsoft Excel.

·       It would open Navigator page, which would have Display Options like this:

·       Select AzureEdison Table and click Load option available at bottom. This step would import your data from SQL server available in Microsoft Azure into Microsoft Excel.

·       Now you can do any processing in your data offline also. 

     

      Happy learning and please post your comments below:-)