How to export data from Excel to SQL Azure?

microsoft-excel sql azure

11,516

To import data from Excel to SQL Azure you'll need to connect to a local server and use Import/Export wizard, since it's not visible from the Azure connection.

when you connect to a local server go to tasks -> Import data and connect to Excel and your file:

enter image description here

Click Next and connect to your SQL Azure db:

enter image description here

And follow the wizard.

Here is also the video describing the whole process in detail with some tips: http://www.sqltrainingonline.com/microsoft-excel-to-windows-azure-sql-in-10-minutes/

Hope this helps

11,516

Techboy

An SAP Technical Architect who likes all technology, gadgets, sports and too many other things. Has dabbled in: ABAP, BASIC, Pascal, C# .net, COBOL, Cold Fusion, CSS, Google App Inventor for Android, Javascript, Java, Java for Android, C++, HAML, HTML, XHTML, HTMLB (for SAP ITS), PHP, SASS, SQL, VB, XML as well as others - but I don't confess to being an expert in any of them ;-)

Updated on September 18, 2022

Comments

Techboy almost 2 years
I know how to import data from SQL Azure into Excel
```
From Excel go to:

  - Data
  - From Other Sources
  - From SQL Server
```
I want to manually edit data and post it back to SQL Azure. What is the best way to do this?
Burgi over 8 years

Are you sure? The OP was asking about a cloud based SQL instance which needed an intermediate step.