Archive

Posts Tagged ‘Microsoft Excel’

Using Microsoft Excel to connect to SQL Azure Database

June 1, 2011 Leave a comment

In this post, we will see how to connect to SQL Azure server from Microsoft Excel and browse and view data

Open Excel 2010 and click on “Data” tab in Ribbon bar

image

Click on “From Other Sources” and Click on “From SQL Server”

image

Please enter SQL Azure Server Name and then select “Use the following User Name and Password”, specify user name and password and click on “Next”

image

Select the database and then select the View or Table which you want to connect to

image

Click “Next” to proceed

image

If you want to save the password, click "on “Save password in file”  and then click “Finish”

image

Select how you want to display the data and then click “ok” to download and view the data from SQL Azure database

image

This helps in quickly prepare a report and charts from SQL Azure data using Microsoft Excel.

Categories: SQL Azure Tags: ,