excelcreate-tableazure-data-studio

How can I copy data from an excel file into Azure DataStudio to create a table with it? (on a mac) thanks


I have a table I made in excel and I want to have the same table in my Azure DataStudio, how can I copy the data over? Thanks!


Solution

  • You need to install the extension SQL Server Import. Also, you should have a database server and a database that are ready to use. The extension provides an import wizard that you can open by clicking Ctrl + I.

    N.B: The wizard will create a new table, it is not possible to insert the data in an existing table

    You will find more details in this article https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/import-and-export-data-with-the-sql-server-import-and-export-wizard?view=sql-server-ver15.

    enter image description here