How to Fix SQL Database ODBC Driver Error

Importing Excel file data to MS SQL Database using SSMS can come with some challenges.

When your data is over 65k records, you wouldn’t be able to use the 97-2003 version as you will lose data.
Most of the time, the SSMS and MS SQL Server are running on 32 Bit and you will need to install a missing component Microsoft Access Database Engine 2016 Redistributable.

You are to download the 32Bit version even though you run a 64Bit Machine.
You are likely to have challenges installing the 32Bit as seen in the video, but using the cmd
1. Cd to the directory where you downloaded the setup
2. Type the name of the setup file including the extension .exe
3. type "/quiet" to bypass the error and get the 32Bit version installed.

Useful resources
#sql #database #ssms

[princeagyiri]

You are the man !!!! I spent the whole of yesterday trying to fix this same problem until I saw this video. Thanks !!!!🙏🙏🙏

[thelmadike]

You're such a lifesaver. After two days of troubleshooting and endlessly scrolling on YouTube, I finally found the answer, thank you!

[ayodejiidowu]

You've gained a new subscriber for sure! After spending more than 5 hours attempting to overcome this challenge, your solution worked exceptionally well.

[allanrousselle]

Using SQL Server 2016. Was required by my enterprise admins to upgrade my older version of MS Office to 2019. Everything seemed to be working fine until I went to load data using the import wizard as you were showing in this video. Same error messages. Your solution was exactly what I needed to fix the situation, and it worked on the first try. Thanks for posting this!

[kanyinsoladiyan]

This video right here is the solution I really need. I've been encountering this for over four hours and this video proferred the solution. Thank you, boss!

[Jjeoma]

You are a real life saver. Thanks sooo much. I’ve been battling this issue for two days wow! This solved it straight up.
I put my files in 97-2003 format and it worked but I lost so much data my queries weren’t making any sense.
Thank you so much for solving my problem

[sandrar]

You are a genius!! I was stuck on this for hours, had to leave it and come back a few days later. Thank you so much for sharing this!

[krabpink]

I know people in the comment have already said this but thank you so so so so much! Your video was straight to the point and easy to follow. It was very detailed and illustrated at the right pace.
Again, thank you so so so much. You've helped many lives out there (including me!) Wishing you a best life ahead!!!!

[Amarathel]

Thank you very much🙏. I was working on this for about 3 days and got exhausted.This video is indeed a lifesaver

[windrexokoth]

This is really helpful, spent loads of time trying to fix the problem. You handled it well

[elishahussain]

I spent a couple of days trying to resolve this issue, i had many breakdowns. Wish i found this video earlier . Much Appreciated .

[sergiorojas]

What an excellent solution for what others just recommend to use Excel 91-2003. Thanks a lot for sharing!

[oluwasegunraimi]

Thank you for sharing. for more than a month now, I’ve been faced with this problem. Thank God i got to see this today on your channel. Stay blessed

[mariemammar]

I lost 5 hours to handle this big issue and finally I found your excellent video !! you save my work

[monicabright]

Thank you so much for this video. You just helped me import 332565 rows of data from excel to sql server after almost 3 days of being stuck and searching for solution.

Thank you.

[jambaraz]

Thanks man, spent half of an hour on fixing this, your instructions helped lot faster.

[mdsaidulislamsayed]

My bruddah! You saved me from going insane. I also wanted to mention that your instructions were actually working for me NOT with the server but WITH THE SQL server DEVELOER version.

[lizsilva]

I cannot thank you enough for having shared this!!! I am starting my journey in learning Data Analytics and this really helped me out. I was getting frustrated already!

[NegasiDawitsalvationhistory]

My goodness. Great job. I spend several days to import data from excell. You solved my problem. Thank you so much. May the good God bless you and keep you through out your life.

[mattbutler]

Excellent workaround, struggled with that for years!