How to upload Excel files into SSMS | Microsoft.ACE.OLEDB.16.0 SQL is not on the local machine error

[@AanchalSharma-ih9pb]

Thankyou so much for this !!! Its the only tutorial that worked for my SQL error. Really helpful !!

[@letsBe.Analyst]

Good to hear ☺️

[@atharvathatte9335]

So far this is only one video which tells us what exactly is needed and works well. Thank you!

[@letsBe.Analyst]

Glad to hear

[@legacyforfitness3096]

Thanks bhai. I was trying to import excel but every time same error i had gone through many videos but not helped but when i saw your video i was able to import. Thnanks once again.

[@sols9019]

OH MY Gosh!!! You're the only person who were able to help me to fix my sql error!! Hope you wont get demotivated making more videos like this!

[@letsBe.Analyst]

Loved this

[@rambostudycentre]

Thank you brother. I was just learning mysql microsoft from a tutorial in youtube and this error came and I was just stucked. Also the tutorial also doesn't know how to solve this problem. I searched in youtube and your video came up. Thanks brother ,it really helped. Looking forward to more videos

[@krishnapriya038]

From where you are learning SQL

[@letsBe.Analyst]

He is learning from a TH-cam tutorial, It will be great if you connect me on LinkedIn and lets find the best SQL for you.
www.linkedin.com/in/durgeshanalyst

[@alexmecwan9247]

Thank You Soo Much Broo.!! I actually Wasted 5-6 hours solving this problem using ChatGPT but then you Came....!!! ❤ The Fault is in Microsoft Website the X64 Version not running properly...

[@letsBe.Analyst]

Happy to help

[@yugarajtamang1056]

thanks brother. been stucked on this one for 3 days. finally problem solved. Good job !!!

[@letsBe.Analyst]

Glad I could help

[@fatizahra5949]

Excelent , it work, you made my day many thnaks from Morocco ...

[@letsBe.Analyst]

Happy to hear 😊

[@JigarJohn-d1c]

Thank you for helping bro🎉

[@LJMAndre]

Thank you so much. It helped me the correct the error message I had when I wanted to upload the excel file in ssms

[@letsBe.Analyst]

Glad to hear that

[@michaelsolomon6033]

Thank you so much, this is indeed helpful

[@bhaveshahuja11]

Thank you bro!
It was really helpful :)

[@mobinafarhanpoor3449]

God bless you ❤

[@pranayrawat1]

worked perfectly....thanks bro

[@SmartMoneyForexUniversity]

This helped alot thanks sir

[@AnshulKumbhare]

This trick was so helpful brother
Thank you so much

[@letsBe.Analyst]

Always happy to deliver good content, just demand.

[@itstooba7]

Thanks dude .. it worked like magic ✨❤

[@letsBe.Analyst]

Always happy to deliver good content, just demand.

[@dmojesh1514]

Thank u so much brother... God bless u💌

[@letsBe.Analyst]

So nice of you

[@tanveerhussainshah8762]

thank you!God bless you. It worked well.

[@minnoo]

What a fantastic way!!! Thanks million

[@letsBe.Analyst]

Thanks for your lovely comments 😊

[@DebsankarPal-m4z]

Thank you so much. It worked perfectly

[@letsBe.Analyst]

Always happy to deliver good content, just demand.

[@mmtsa]

Hello.
I've done all the steps carefully and still getting the same error.
I installed the same version of OLEDB provider which is 16 and also have run the commands in my Command Prompt just like you but not being able to import data in my sql server database.
I've seen multiple tutorials about this and in all of them, the solution has worked like a charm but for me, nothing positive is happening.
Any suggestions?

[@letsBe.Analyst]

Kindly check again might be you missed something

[@lydia_edwin]

Same thing with me 😢
I'm tired

[@rabiatayyab2568]

same issue. Did u find any soln?

[@letsBe.Analyst]

Will come with another video

[@karthikt1737]

Thanks a lot for this tutorial .

[@letsBe.Analyst]

Always happy to deliver good content, just demand.

[@mnacreations543]

thanks, men, it is really helpful.

[@letsBe.Analyst]

Always happy to deliver good content, just demand.

[@maryumfatima8191]

Thanks, it worked 👍🏼

[@primeminister5581]

crisp and nice content
worked

[@letsBe.Analyst]

Always happy to deliver good content, just demand.

[@khaledabouwalid1727]

I LOVE YOU BRO THANKS A LOT

[@systemdown4027]

Super Super thanks Man! Subscribed!

[@letsBe.Analyst]

Loved it

[@Random_Guy_Bharatwale]

Great bro
Thanks

[@lakshyarathore4669]

I have 70 lakh rows data and i want import in ms sql but it didn,t work my excel formate is msexcel workbook

[@letsBe.Analyst]

Yup However in Excel, there are only 1048576 rows in one sheet but if you have in multiple sheet even then you can do it.

[@HaiderAliZulfiqar-lo1ul]

very good

[@debasishmahapatra7416]

Thanks Mate
It worked!

[@wingit9529]

Thankyou so much !

[@g8rrard]

Great Job!

[@shajahan-cp3fu]

Thank you bro it's worked. But my only doubt is why should we go with 64 bit? Is this same process applies to the 64 bit?

[@letsBe.Analyst]

Mainly integration is built on 32 so

[@MaiNgoc-rd9gb]

is that sql developer version? i have try so many time with my sql express version but it doesn't work at all

[@letsBe.Analyst]

It should work for both

[@memereaper870]

It worked.. Thank You

[@letsBe.Analyst]

Always happy to deliver good content, just demand.

[@alonemast8445]

Thanks buddy..❤

[@atalhasecilir]

Thanks buddy!

[@harshikaaa777]

Hello sir, after doing this steps its still giving error.. i tried importing flat file but its also not slowing the data..

[@letsBe.Analyst]

Hello there,
Please check each step carefully, you will get it.

[@harshikaaa777]

Okk sir can you share your LinkedIn profile.

[@letsBe.Analyst]

www.linkedin.com/in/durgeshanalyst

[@harshikaaa777]

Got it..😌

[@rinturoy8014]

lovely bro,
is SQL so important to crack an interview?

[@letsBe.Analyst]

Yes Rintu, if you want to become a data analyst then it's must

[@thanushramesh2329]

Thank you so much!

[@letsBe.Analyst]

Warm welcome 🤗

[@silamshelia6239]

Thank you so much

[@abhilashbantupalli994]

Thank you boss

[@Indian.fitness7]

Bhai apke instructions se maine jo download krna tha vo kiya h setup v after that also when I'm selecting ms Excel 16 version it shows the ms. ACE. OLEDB. 16.0 provider is not registered on the local machine???

[@letsBe.Analyst]

System configuration 64 but me bhi 32 bit OLEDB download kiye ho aap?

[@kiran8145]

Bro can you please make video on how we can import multiple Excel files at once in SQL server

[@letsBe.Analyst]

Sure

[@vampire__hunter]

thanks it worked

[@onlineaakashvani6145]

Hello brother please help me , i open server in local directory but it doest shows any file. It only show my adminstration files. How can i acess local directory files in sql server . Please reply or suggest any video😢.

[@letsBe.Analyst]

Will share a new video soon.

[@vikasnagar8768]

but it will change the data type of all variables

[@wordsaholic12]

THANKK YOUUUUUUUUUU

[@dinahany233]

THANK U SIR

[@legiahuy7763]

thanks a lot

[@khushboosharma661]

Thank you

[@vanajauppathi]

It's not working for me😢

[@letsBe.Analyst]

What are your issues?
Watch this completely.

[@ggwp8379]

Tysm brother

[@TechInsights-x4r]

After all these steps i am still unable to import data into sql

[@letsBe.Analyst]

What error are you getting?

[@TechInsights-x4r]

@@letsBe.Analyst thanku for replying... Its resolved now

[@letsBe.Analyst]

Osm

[@rambostudycentre]

share your linkedin

[@letsBe.Analyst]

linkedinwww.linkedin.com/in/durgeshanalyst?

[@Aaakash_guptaG]

Still bro vahi Show kar raha

[@letsBe.Analyst]

No worries I'll come up with a new video

[@NeethuNV-n3o]

Thank you so much