How to Import Data from Microsoft Excel to Windows Azure SQL Database - Quick Tips Ep44
How to Import Data from Microsoft Excel to Windows Azure SQL Database - SQL Training Online
For the links to the samples used in the video, you can go here:
http://www.sqltrainingonline.com/micr...
TABLE OF CONTENTS
00:00 - Intro
01:37 - Create SQL Server in Microsoft Azure
02:56 - Connect to Azure with SQL Server Management Studio (SSMS) - Connection Failed
03:15 - Open IP Address to SQL Server in Azure
03:55 - Connect to Azure with SQL Server Management Studio (SSMS) - Success
04:45 - Import Export Wizard
07:21 - Add Clustered Index
08:50 - Execute Import
DESCRIPTION
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.
I show you how to setup a new Azure SQL Server.
Then you will see how to open up a firewall port that allows you to connect using your local SQL Server Management Studio.
Finally, I show you how to connect to a Microsoft Excel Workbook using excel connections and push that data over to your new tables in the SQL Server on Windows Azure.
READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE
http://www.sqltrainingonline.com/micr...
YOUTUBE NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
http://www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
http://www.youtube.com/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
http://www.sqltrainingonline.com
LET'S CONNECT!
Facebook: / sqltrainingonline
Twitter: / sql_by_joey
Linkedin: / joeyblue
SQLTrainingOnline: http://www.sqltrainingonline.com
Смотрите видео How to Import Data from Microsoft Excel to Windows Azure SQL Database - Quick Tips Ep44 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Joey Blue 15 Ноябрь 2012, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 46,459 раз и оно понравилось 355 людям.