A number of people have found my post about getting started with SQL Azure pretty useful. But, it's all worthless if it doesn't add up to user value. Database are like potential energy in physics-it's a promise that something could be put in motion. Users actually making decisions based on analysis is analogous to kinetic energy in physics. It's the fulfillment of the promise of potential energy.

So what does this have to with Office 2010? In Excel 2010 we made it truly easy to connect to a SQL Azure database and pull down data. Here I explain how to do it.

By following these steps you will be able to:

1. Create an Excel data connection to a SQL Azure database

2. Select the data to import into Excel

3. Perform the data import

All mistakes herein, if any, are my own. Please alert me to potential errors.

Import SQL Azure Data Into Excel

You need to be running Excel 2010 (post-Beta 2 builds) for these steps to work properly.

In Excel 2010 select the Data tab on the Office Ribbon. Choose Get External Data and then press From Other Sources. In the resulting list select From SQL Server.

clip_image002

The Data Connection Wizard launches. Add the server name (for SQL Azure), user name, and password. Then press Next.

clip_image004

The wizard will then let you choose the table or view. Choose a table or view and press Finish.

clip_image006

The Import Data dialog lets you select where you want the data to land in Excel. Choose a location and press OK.

clip_image007
   

The designer will display your tables. You can close the designer after adding the tables.

clip_image009

Now, the user can work with the data just as with any other collection of data in Excel. Excel can save your connection information as a *.odc file so that you can re-connect any time.

Resources

· Getting Started Integrating Windows Azure with Microsoft Office Solutions


Rock Thought of the Day:  Listen to the Song "The Weary Kind" from the film Crazy Heart. This is what country music is all about at it's core. It's not pop glitter or just a lazy twang, my friends. It's about heart-ache and pain, about loss and yearning, about trying to measure up in our hearts to what our dreams tells us we can be. Country music was my first music love-affair. I listened to Trini Lopez, George Jones, Buck Owens, Johnny Cash, Loretta Lynn and so many more. Their songs had soul and stirred something in me that has never settled down going on four decades later.

Rock On