how to import excel file data in azure sql table.

Hi,

Aditya Answer :

Import the data into Excel from SQL Server, using the tab DATA -> Existing Connection -> SQL Server. You can write specific SQL to import data or simply import the table. Adding more, using the Refresh All under the same DATA tab, you can refresh the data anytime & be in sync with the SQL Server table.

Please check the following reference :

http://stackoverflow.com/questions/15483369/data-import-excel-to-sql-azure

http://stackoverflow.com/questions/36171188/export-data-from-sql-table-to-excel-without-data-flow-task