Using Microsoft Excel to connect to SQL Azure Database


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.

Author: Arunraj

I am a Microsoft Certified Technology Specialist (Database Developer). I work on SQL Server programming since SQL Server 7.0 specializes in SQL Server Programming and Performance Tuning and has 14 years of hands-on experience. I hold a Master Degree in Computer Applications. I am also part of NJSQL User Group and Northern New Jersey .Net User Group.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s