how to import excel file data in azure sql table.

Question

Hello All How to import excel file data in azure sql database table. without using SSIS.

Rajeesh Menoth · Answer

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