Home > SQL Azure > Using Microsoft Excel to connect to SQL Azure Database

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.

Advertisements
Categories: SQL Azure Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: