How to import flat file/CSV file in database in Microsoft SQL server Management Studio?

In this video tutorial, we will learn to import a CSV file into the database by using the SQL server wizard in SQL server management studio. This is a very use ful trick to import CSV data files as tables. and you can import huge data files in no time and be smart.
#sqlservermanagementstudio #sqlserver #sqlservertutorial #coolithelp

[@xyanglui7795]

thank you, u r great

[@bokkenknuser]

This is very useful! Thank you!

[@CoolITHelp]

Glad it was helpful!

[@chandanprasad4634]

Thank you! 👌

[@justthien]

It takes pretty long to insert data at the final step, I don't know what's wrong, whether if my data is too big (around 160k rows) or my computer is just weak (8GB RAM)

[@Daughteroffice]

Thank you.

[@baturalpince456]

how do you setup foreign keys while doing this?

[@homed41763]

How to add to a already existing table

[@rmehta26]

Is it possible to import several flat files (.csv) together in one go?

[@othukeprecious3693]

Thanks

[@valentinvas6454]

Why is that when I go to tasks I only see a few options. There are no such thing as import flat file???

[@mestermester6749]

What happens if in that case the delimiter is the comma "," but you have a column that internally has commas? For example "x value, y value, z value,"... the SQL divides this field into columns and it would be wrong because "it interprets the delimiter of said column as new columns", how is this fixed? Thank you!!!

[@xueyu4634]

did you manage to fixe it ? I have the same problem :(

[@mestermester6749]

@@xueyu4634
Hello, no, I couldn't solve it from sql server, I had to make a stored procedure that controls the number of commas and solve the problem with transact-sql.

[@Juzz_RSA]

Thank you

[@CoolITHelp]

You're welcome

[@chenghuisg]

Can insert csv to a existing table?

[@homed41763]

How to add to a already existing table

[@CH-zp1zv]

thanks dude

[@CoolITHelp]

Happy to help