SQL Training Online

  • Training Courses
  • Beginner Book
  • Blog

November 15, 2012 by Joey Blue Leave a Comment

Microsoft Excel to Windows Azure SQL in 10 minutes

Video: Microsoft Excel to Windows Azure SQL in 10 minutes – SQL Training Online
In this video, I walk you through setting up a Windows Azure SQL Database and then importing some Microsoft Excel data. I show you a trick to get the SQL Server Management Studio Import/Export Wizard to work for a Windows Azure connection.

How do you import data into Windows Azure?

There is a pretty easy way to import data into Windows Azure using the SQL Server Management Studio Import/Export wizard. But, you have to use a little trick I came up with to make it work.

I found a sample project over at CodePlex by Derrick VanArnam that demonstrates how to import Microsoft Excel data into Windows Azure.

It has a sample Microsoft Excel file and a Microsoft Word document that walk you through using SQL Server Integration Services (SSIS) for importing the Excel file into Azure.

ExcelToAzureIn10Minutes

In the video, I cover the following.

• Login to Windows Azure

• Create a SQL Server

• Create a Database

• Connect with Management Studio

• Show you a trick for Import/Export Wizard

• Move Data from Excel to Windows Azure

 

After you create a Windows Azure database, you will have to allow your IPAddress access through the Azure firewall.

Then, you open SQL Server Management Studio and connect to your database.

Now, create a new Azure database with the following script.

 

CREATE DATABASE [Olympics]
GO

 

It’s now time for the trick I mention.

By default, you won’t see the Import/Export wizard on the menus in the Azure connection.

You have to open up another connection in your Object Explorer in Management Studio. You should make this new connection a non-Azure database.

Then, you will see the Import/Export wizard.

Next, you will need to connect to the Excel File and the Azure Database.

One last trick, is to make sure your new tables have a clustered index.

Insert the following into each of your excel create table scripts as the first column.

 

id int identity primary key,

 

Finish the wizard and watch the data go into the tables.

That’s it. That is how you import data from Microsoft Excel to Windows Azure SQL database.

 

*Let me know what you think by commenting or sharing on twitter, Facebook, google+, etc.

You can visit me at any of the following:

SQL Training Online: https://www.sqltrainingonline.com

Twitter: http://www.twitter.com/sql_by_joey

Google+: https://plus.google.com/#100925239624117719658/posts

LinkedIn: http://www.linkedin.com/in/joeyblue

Facebook: http://www.facebook.com/sqltrainingonline

Filed Under: SQL Training Tagged With: Cloud, Microsoft Excel, SQL Export, SQL Import, SQL Table, SSIS, Windows Azure

Recent Posts

  • SQL Database Normalization – 1NF, 2NF, 3NF, and 4NF
  • SQL Joins Tutorial for Beginners – Inner Join, Left Join, Right Join, Full Outer Join – SQL Training Online
  • Zillow House Price Analysis from CSV Archive – #PowerBI 002
  • Learn Basic SQL – 1 Hour Training Course – SQL Training Online
  • Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset – SQL Training Online

Popular Posts

  • SQL Functions
  • SQL Jobs in Oracle and Microsoft SQL Server
  • Troubleshooting a SQL Join
Copyright © 2025 · SQLTrainingOnline.com · Consulting at EmbarkBlue.com