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!
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.