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:
----
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.
We'll also look at how to solve the "'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine" problem.
----
Links to my website are:

[alexniyonzima]

After a whole day of hitting dead ends I land on this helpful video. Thank you

[Lolomikagi]

OMG, thank you so much!! I could cry right now. I spent 8 hours trying to figure this out on my own.

[MuxicMax]

Thank you soo much I spent 2 literal days to understand this after installating tons of connectors and other driver this has eventually worked sir I owe you my life...

[deannamccloud]

Thank you for this video! Took me 2 days plus uninstalling + reinstalling SQL multiple times before landing on your video. Thank You again!

[pw]

Excellent Video. Thanks. Finally got the spreadsheet into SQL.
Only problem was it took me days to get the Import Export function up and running. Kept getting an error message saying DTSWizard was missing. Finally solved.
Hopefully this method will also work for Access Databases.

[zipporahebede]

thank you so much. this video helped me so much, was almost losing hope. uninstalled my sql server so many times because i thought that was the issue

[marc_aussie]

Thank you, info on using the DB driver instead of native client was very helpful, as well as how to fill out the properties box. Got my data loaded!

[akindeleadebayo]

Thank you sir oo. Finally able to import my data😀😀😀 after several attempts.

[TimelessView]

Oh my god thank you, thank you so much. I've been struggling for the past few weeks 🥺🙏♥️♥️♥️

[randalsullivan]

A great video, thank you for this series!

[adewunmiroland]

Now this is what I call quality content.🤌

[zuyderrathaman]

Hi there, I still get the error you mention at min 5.43 (import wizard, MS ACE.OLBD 1.6 provider) even when I install the Microsoft Access Database Engine 2016 Redistributable. Kindly assist

[saojoaomeriti]

Thank you so much!

Is it possible to conect Sharepoint list to SQL Server?

[tcells]

it's been weeks now that I've been trying to fix the import data problem. Unfortunately, I still have the same error when importing an excel workbook like it was shown in this video. Can someone reach out to me directly because I have tried this a million different ways and not sure what other options I have at this point?

[nochu]

i have almost 200k data, i tried to import all data but only 40k were imported, may i know how can i solve this?

[paulntumbong]

I used this method in creating an ssis package, but I could not find the package after setting it up

[vinayakbhardwaj]

I also did the same steps as you did but am getting extra columns and rows with null values.
What can I do now

[mmtsa]

Hello.
I've done all the steps and also have installed Microsoft Access Database Engine 2016 Redistributable just like your tutorial and still getting the same error and no OLEDB provider has been installed on my Windows 10.
What might be wrong when this happens?
It says the installation was successful but the I can't see its reflection on my job.
Any suggestion?

[patryknejmanowski]

Do files from Excel 365 work too? You only mention Excel 2019 and 2022 working while selecting Excel 2016 during import.

[mestermester]

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!!!