SQL Query | Load data from CSV file into database table | BULK INSERT | OPENROWSET

In this tutorial, we take a look at two ways using SQL Query to load data from a csv file into a database table.
We use the BULK INSERT and OPENROWSET functions.

Below is the link to all SQL statements related to this video -

Microsoft documentation on OPENROWSET and BULK INSERT

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate

Google Advanced Data Analytics Professional Certificate

Practice SQL Queries on Your Browser through Interactive Courses -

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

[MyxaTcakatuha]

Why would anyone use second method? Its complicated and requires lots of preparation so i wonder if it is any real purpose, or its presented just as example that its possible?

Sorry for maybe stupid question.

Btw i use regular instrument "import data" in oracle sql developer, thanks to your video i understand deep processes, taking place on importing via tool so anyways educating, thank you

[Tabla_Tejas]

Great Efforts From You Mam Thank You So Much🙏🙏🙏

[designanddecor]

Wonderfully well explained. Really solved my problem 👍

[penchalaiahchandu]

Thank you so much... Your videos very helpful

[prateekkumar-xcuo]

I am getting this error : Cannot bulk load. The file does not exist or you don't have file access rights.

[vincentchidiebere]

Hello, thank you for this video it was helpful. Nevertheless, in my case; I need to be repeating this procedure every morning with new dataset of equal columns, so that the table in my database is updated on a daily, does the bulk insert and openrowset solve this? Thanks

[hasanmougharbel]

God bless your great efforts in this channel.
I have a simple question to ask as a newbie sql learner.
Could i manage to channel or extract all sql data generated from an accounting program (based on sql) to our new sql server.
The reason that we are bounded with the graphical interface of this accounting software as we cant
come up with any solutions regarding analytics and automation, unless we can tailor and rearrange this sql database based to our specific needs.
Thanks for helping me.

[clivesibiya]

Thank you for the this video. I am struggling using the second option because my case is different. I want to be able to use a query for different files, I might not know the data contained in the csv since I am planning to automate it. Is there a way of creating a format file automatically??

[KarthikH-cwug]

Msg 4860, Level 16, State 3, Line 1
I am receiving this error Cannot bulk load. The file "C:\Test.fmt" does not exist or you don't have file access rights.

[saktibiswal]

I use bulkinsert at work too. But it has its limitations. Sometimes I get pipe delimited CSV files where the column values are surrounded by double quotes. When we use bulk insert with such a file then the columns in table also get double quotes around it. Is there any solution to load the data without the double quotes?

[hasanmougharbel]

Hello, very informative video. looking forward to learn more from you.
As a newbie to the SQL language, i am wondering if there are any limitations or drawbacks if i start as a beginner to work
with Microsoft SQL Server 2008 Express. (old version)
The reason that i am bounded with my pc hardware specification and windows 7 installed, but I am still eager to learn this language no matter what the boundaries are.

[mohammadzaman]

Question:
To laod data from CSV into SQL table, I had to declare all data type in SQL table as nvarchar.
Is there any way to Load data from CSV to SQL table with different types ( eg: int, nvarchar(50), date...)
without using MS Visual Studio SSIS ?

[Munichandra_Reddy]

Hi there!
Ex: how to extract data, how to store data into multiple tables, and how to send data from staging server to data warehouse using store procedure, please explain 🙏🙏

[Deepratan]

It's not working in Oracle SQL Developer