Import CSV to SQL Server using Azure Data Studio

preview_player
Показать описание
Learn two ways to import a CSV file into SQL Server using Azure Data Studio. This is a great option if you are like me and use a Mac for development but use SQL Server as your database.
The two options, that I know of, are using SQL Bulk Insert, and the SQL Server Import extension

Docs for Bulk Insert

Follow me on social media!

Check out my blog!
Рекомендации по теме
Комментарии
Автор

The most straight forward data import tutorial and I just spent hours watching multiple different videos. 🥰

marchismo
Автор

Thanks a bunch! Long time SQL Server user, first time running Azure Data Studio on macOS/Docker. I am super glad to see that there is decent extensibility and additional tools. Grateful for your helpul information.

veccio
Автор

Two videos that helped me in one day, thank you!

Reglaized
Автор

Thanks a ton. This is very helpful for Mac users who love Microsoft Business Products and Services.

top__percent
Автор

Thank you for your clear & comprehensive explanation!!! I was attempting to use the SQL Server Import in Azure Data Studio to import CSV and TXT files. It absolutely would not work and just timed out. Now I know another way to do it! Thanks again.

oliverselwyn
Автор

Thank you so much! You made it so clear and easily!

ettrxqy
Автор

Thank-You, Thank-You, Thank-You! Awesome video and I love the NASA t-shirt! Just knowing there is at least one other human being using Docker/Azure Data Studio for SQL makes me happy! I have experienced LOTS of headaches importing Excel as a CSV file. Recently, I've encountered challenges when dealing with dates. My best guess is that the Excel date data may be a bit wonky, or gets wonky when I "Save As CSV". Any "dealing with date data" experience you can share? Keep up the great work. You've earned my subscription to your channel AND a heartfelt "Like" for your efforts. Cheers! 😎

kqtctuc
Автор

Very nice and informative, thanks and keep it up.

shahnawazk
Автор

great hint. Thank you. save me a lot of effort

trieutruong
Автор

you have earned my subscription sir, thank you

musawasheshambare
Автор

Thanx for the explanation. There is one more way through which we can easily import the CSV files in Azure Data Studio by installing the "SQL Server Import" extension from the extension store.

RahulP
Автор

Thank you for making a Mac/docker with Azure Data Studio video, still in the learning process helped a lot. Is there a way to import xls file as if I try with the extension it greys-out the xls files and I not able to import the file.

amananand
Автор

Thank you! I only have an issue with the second option using the extension. I downloaded SQL practice projects, which I am attempting to import into my Azure studio, but it wouldn't run after importing as its imported directly as an SQL file instead of a CSV. Any suggestions on how to change the SQL files to csv before importing into studio?

ayooluwatomisowole
Автор

What in case I already have a table and I want to append data

haithamdarweesh
Автор

Hello! thanks for the video! Do u know how to import data into the existing table in Azure Data Studio except standard INSERT INTO command?

hfhnrbq
Автор

this was very helpful, do you have any videos on data analysis on youtube?, i would really love to learn from you . i am just starting out tho

abdulhakeemsanni
Автор

Thanks for the vid. Is there a way to import CSV into existing table with SQL Server import using primary ID's? or similar?

munfordable
Автор

for some reason when choosing the "database the table is created in", my only option is "master" and not the db that I have created even though i didn't have the same problem before. Do you know why this problem is happening? Thanks in advance

lanzly
Автор

Do you have any idea on how to import an excel file with multiple sheets to SQL Server? I use mac also, and when I tried using the Import Wizard, the data becomes crazy with weird characters.

winstonmulyawansetiabudi
Автор

Thank you very much but how could I delete a column before step 4?

HenryFake
welcome to shbcf.ru