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.
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.
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.