How to Fix SQL Database ODBC Driver Error
HTML-код
- Опубликовано: 8 сен 2024
- 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.
Link to the Access Database Engine Setup : www.microsoft....
Useful resources
Kaggle Data: www.kaggle.com...
Setup SQL Server on your PC and Install Adventureworks Database: • Practical SQL Beginner...
Understanding Adventureworks Database: • Understanding Adventur...
#sql #database #ssms
You are the man !!!! I spent the whole of yesterday trying to fix this same problem until I saw this video. Thanks !!!!🙏🙏🙏
Me too Thanks you so much for do this video
You're such a lifesaver. After two days of troubleshooting and endlessly scrolling on RUclips, I finally found the answer, thank you!
So glad you found this helpful
Oh yeah, baby! I'm saving this video for my grandkids. Because I don't think Office will ever fix this. Thanks my friend, greetings from Argentina.
Thanks alot ....right after i encounter this problem i got your video and fixed the issue within 10 mins
Glad it helped
Thank you, out of all available sources online this gave me the solution I needed.
Glad it helped!
Yes dude I am also facing same problem now peacefully completed
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!
Man, you literally made me cry because mine started working, i was so so sad, bcs it wouldnt work but now it does, THANKYOU
works 100% basically its the 32 bit which sql ssms server . so using cmd it can be installed
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.
You really dont know what you have done for us. I was almost quitting not until i found your channel. Thank you so much Boss
Glad I could help
Someone please buy this man a few from the top shelf. Ekushe o 👍✊
Thank you so much for the encouragement
Thank you very much for the clear explanation, it helped me a lot
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.
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!
Not even chatgpt could fix this problem. Thank you so much man!
Glad you found this helpful
I truly appreciate you for this! Thank you.
I'm following you right away.
Awesome! Thank you for the support
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!!!!
Sir , You are Genious .. i am trying to upload the data.. finding so much trouble in it .. Your vedio sovled all my problems ... GOD BLESS YOU ....
😘😘😘😇🥰🥰🥰🥰😍😍😍🤩🤩
you saved my day man.i had this issue with several days and i wasted 3 days without doing anything.Thanks a lot
Thanks Boss, I've been battling with this error for about two days.
Ah Senior man, he have no idea how much you have saved me with this solution. I don try taya nothing until this. I have been able to upload my files now.
Thant's amazing, I spent whole day, watched numerous videos related to this issue, but couldn't solve this mystery. Your instructions are so easy to follow, and to the point. Thank you so much for all your time, and help, much appreciated.
So glad you found the video helpful. Thank you for the encouragement
I spent a couple of days trying to resolve this issue, i had many breakdowns. Wish i found this video earlier . Much Appreciated .
Thank you so much!! I've spent the last hour trying to solve this problem. You are amazing!
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.
Thank you so much. I've been trying to find a solution for this for the past 4 hours and came upon your video.
Glad I could help
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!
Glad you found this helpful
very useful video thank you man i spent days trying to fix this problem you manage to explain the issue i needed to fix my problem thank you
Glad it helped
Great video!!! spent half day in figuring out the resolution.
After spending about 3 hours fixing this issue. You solved it in less than 5 minutes. Thank you!!!!!!!!!!!
God bless you, my man. Saved me from mental breakdown
I lost 5 hours to handle this big issue and finally I found your excellent video !! you save my work
Thank you so much....was struggling to get this done. 👍👍👍
Glad it helped
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
Thanks man, spent half of an hour on fixing this, your instructions helped lot faster.
thank you so much bro, i went to countless forums and tutorials, yours is the only one that helped me! thank you thank you!!!
What an excellent solution for what others just recommend to use Excel 91-2003. Thanks a lot for sharing!
Finally, spend about 2 hours to fix this. Thank you very much sir 💞
You've gained a new subscriber for sure! After spending more than 5 hours attempting to overcome this challenge, your solution worked exceptionally well.
THANK YOU!! Spent SO MUCH time trying to get this to work and finally found a link to your vid via a community Q&A post. ThankYouThankYouThankYou
I almost get rid of my PC due to frustration. Thank you very much, Sir, It works out well, now I can write my queries for my project🙏🏾
Thanks Man !!! I was stuck for hours and didn't know much about the fix. Thanks once again and keep growing.🚀🚀🚀🚀🚀
Glad it helped!
Literally dude You just solve my problem where I am stuck for 2 days tysm
Thank you very much🙏. I was working on this for about 3 days and got exhausted.This video is indeed a lifesaver
You’re a life saver, been frustrated with this for the past three days now 😅
Thank you for this Ola. Look forward the power automate version.
Can't thank you enough, wasted a lot of time on this. You put it straight and simple. Hope you have a good day, thanks
You are a life saver, TRULYYYY!!! Thank you so much man I spent two days on this browsing and you helped fixed it in an instant.
i was struggling with the same problem for last 48hrs. Thank you for the solution!
I normally don't bother liking videos, but props. You got my like. Thanks, man!
Thank you!!!!!! I seriously considered switching to MySQL before seeing your video
Thanx a lot. I was stuck for 3 days, this was super helpful ❤
You're the man, thanks for this guide bro
Glad to help
Thank you , The issue does me have had a headache for 2 days.
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!
You are a live saver!! I can't stress enough. Thank you so much :)
yeeeeeessss thank you so much, been trying to figure this out for days!!
Definitely you are the man. It helps me a lot,. God bless you bro. Greetings from Peru
Many thanks my friend, I spent the whole of yesterday trying to fix this exact problem until I saw this video, THANK YOU SO MUCH.
This thing has been a pain I my ass. Finally managed to solve it with this method. Thanks man.
You sir are a genius. Thank you so much for this!!!
Thank you so much!!! You saved so much of my time, can't thank you enough!
Man, I know that there is alot of thank you in the comments but I must add one more 😂
Thank you man
You are a real champ 😂❤️
Thank you very much. You made my day and resolved my issue. God bless you.
Thank you so much you are a saviour.After so much struggle finally i got a solution
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
THANK YOU FOR SAVING HOURS OF MY LIFE AND MILLIONS OF NEURONS!
not all heroes wear capes, thanks for posting
You are the king my friend, you have the right, thank you very much.
It worked perfectly! Thank you so much!
Thank you brother. You’re a saviour 🙌🏻
Thank brother. You made it Very clear and easy.
when I was about to Quit then I found this video, real life saver
Fantastic. Thanks brother. This issue gave me problems for days. But fixed it now. Thanks so much
I solved the same problem because of your video. Thanks a lot pal.
Thank you so much, it worked! it worked! Finally!
Thanks a lot! The only solution that works.
Muito obrigado pela sua ajuda, estava procurando uma solução para esse problema fazia mais de uma semana 😅
Great work I really appreciate your video it saved my reputation....👍
wow. you have many rich contents this is so helpful. thanks.
Fantastic.
Keep going bro.
You are a hero
this video resolved my problem. thanks bro
You are the man!!! I spent 2 days trying to figure this out, Thank you man!
THANK YOU SO MUCH!!!!!!!! It worked like a charm:D
Thank You. It really helps. Cheers
Glad to hear it!
you did it bro, thanks a lot, this is a lifesaver, subscribed
dude, you are the best. how many lives you saved with it
This is really helpful, spent loads of time trying to fix the problem. You handled it well
So helpful. A big problem for me too.
Excellent workaround, struggled with that for years!
Thank you so much! I got stuck too and your video helped me out
Thank you so much for this very clear!
Thank you so much for this video, sir.
God bless you.
thanks man!! this is only way work and what I need
You are a life saver this worked magic
Beautiful solution! Thanks so much.
Thank you friend. Really appreciated!
You are excellent !
Thank you so much, I've been looking for this fix for many hours already! you saved me a lot of time!
Thank you so much, this strategy worked for me. God bless you.