How to import data from Microsoft Excel into Microsoft SQL Server

In this video, we'll have a look at how to import data from Excel into SQL Server.
My SQL Server Udemy courses are:
----
My Excel for PC courses are:
----
In my previous video, I discussed how to import data from SQL Server to Excel. Now, it is the other way round.
In this video, I show you how to import csv and txt files into SQL Server, and Excel spreadsheets as well.

[willitivity]

This was very informative and awesome. My hours of aimlessly roaming around solved in minutes.

[sunilraja]

I'm searching for simple method to import data wow what an explanation thank you very much

[OscarBalwin]

You are such a life saver! Thank you! Really saved me time in figuring things out :)

[dongnguyen-idpe]

this is so useful and detailed. Thank you for the video!

[skshahbazali]

Thank you very much brother. I have subscribed to your channel, coz of this video only.

[sangeetharamtenki]

Import flat data option is available in ssms v 17.3 or later..can you show how to import in ssms
v10

[JeffersonMartinSynfluent]

If most of us can ever solve the OLEDB 12.0 Provider Registry issues, we might be able to use your import schemas.

[varunakarniya]

wow thank you so much, this really helped

[vlasov]

Спасибо. получилось. Раз 100 смотрел, пока не понял как делать.

[mevkaptan]

thank you so much your clear and understandable expression, i benefited from this video🤘

[riskhibayusarwosaputro]

thank you very much for your great video dude

[greetika-mbrq]

Thank you 🙏😊 so much for this, ,, really it solves my problem queries regarding importing data

[mehrosenasir]

Hi, I followed the same steps for importing a excel file and it throws this error
Invalid object name 'dbo.Sheet1$'.

[kareemmansour]

How to append more excel file to the same tables created

[khonrak]

Listening to this gave me 1 Big Thumping Headache, what happened to all the dynamic sounds of 1970's Punk Rock, hope these guys have improved their musical skills, since 1980, as I remember New Wave - Punk Rock being such an electrifying experience, as I'm planning on attending PIL tour this year, hope they won't disappoint. Shake you're Balls up ! 😮

[hallythejester]

I'm getting a very different menu when I right right click on my database. it doesn't have a tasks button at all. :(

[blanklate]

Is there a way to import from sharepoint? Or excel online

[tvryoda]

Does using the flat file method avoid the 32 bit vs 64 bit issue with the microsoft ole db driver

[ayushisahu]

Thanks the vedio was so helpful but facing few error

[amjadmahmood]

i am looking for a vba code performing the same procedure of flat file import in SQLExpress
Looking forward to your kind advice, its urgent please.