×
Namespaces

Variants
Actions
(Difference between revisions)

Azure Mobile Services - Importing data from Excel

From Nokia Developer Wiki
Jump to: navigation, search
galazzo (Talk | contribs)
m (Galazzo -)
galazzo (Talk | contribs)
(Galazzo - - Importing Data)
Line 34: Line 34:
 
[[File:Sql-server-management-studio-login.jpg]]
 
[[File:Sql-server-management-studio-login.jpg]]
  
Select the server address you choosed during creation of your Mobile Service and select SQL Server Authentication option.
+
Select the server name you choosed during creation of your Mobile Service and select SQL Server Authentication option.<br />
 +
Once logged you can browse your remote databases, tables and perform queries.<br />
  
 +
[[File:Sql-server-management-remote-db access.jpg]]<br />
  
 
== Summary ==
 
== Summary ==

Revision as of 21:18, 18 June 2013

WP Metro Icon File.png
WP Metro Icon Web.png
WP Metro Icon WP8.png
SignpostIcon WP7 70px.png
Article Metadata
CompatibilityArticle
Created: galazzo (18 Jun 2013)
Last edited: galazzo (18 Jun 2013)

Contents

Introduction

In this article will be shown how to import data from an Excel file into Azure Mobile Services in order to be used by your App. It's assumed you have created your own service else follow this guide on how to manage Azure Mobile Services.

Tools

In order to import data from your local database or Excel file you need to install last version of Microsoft SQL Server Management Studio Express (SSMSE), a free and easy graphical tool to use for managing SQL Server database with Advanced Services.

Sql-server-management-studio.jpg

Importing Data

Opening Microsoft SQL Server Management Studio will be asked to connect to a server.

Sql-server-management-studio-login.jpg

Select the server name you choosed during creation of your Mobile Service and select SQL Server Authentication option.
Once logged you can browse your remote databases, tables and perform queries.

Sql-server-management-remote-db access.jpg

Summary

144 page views in the last 30 days.

Was this page helpful?

Your feedback about this content is important. Let us know what you think.

 

Thank you!

We appreciate your feedback.

×