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

user_13460721 0
Viewed 6155

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!

azure-data-studio create-table excel
1 Answers

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://docs.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

user_53948060
Related