From the course: Azure Data Studio Essential Training

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Import data from CSV files

Import data from CSV files - Data Studio Tutorial

From the course: Azure Data Studio Essential Training

Start my 1-month free trial Buy for my team

Import data from CSV files

“

- If you have a bunch of tabular data that you'd like to import into SQL server then you can streamline the operation by installing another extension. Head over to the extension sidebar. And this time we'll do a search for an extension called SQL server import. This extension will read CSV and text files and intelligently create a new database table and assign appropriate data types to each column. Let's go ahead and press the install button to add it to our Azure Data Studio instance. And then I can close the tab. I'll switch over to the connection sidebar. Now we can test it out. I would like to use the extension to add in a new table to the Kinetico database. So I'll right click on the database. And at the bottom we have a new option for the import wizard. The first time you activate this wizard it's going to take a moment to initialize the extension, but eventually it will open up the import flat file wizard. Now…

Contents