Please note that as of October 24, 2014, the Nokia Developer Wiki will no longer be accepting user contributions, including new entries, edits and comments, as we begin transitioning to our new home, in the Windows Phone Development Wiki. We plan to move over the majority of the existing entries. Thanks for all your past and future contributions.
Azure Mobile Services - Importing data from Excel
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.
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.
Opening Microsoft SQL Server Management Studio will be asked to connect to a server.
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.
Now we need to access to a local resourse in order to upload data from local to Cloud. To do that click on connect button on top left of the explore object column and select database engine. Will be shown the same window at startup and select your local address ( tipically localhost or network path ) and select Windows authentication.
if don't have one create a new local database