troubleshooting Question

oledb.16.0 provider is not registered on this machine error message

Avatar of Ian Bell
Ian BellFlag for United Kingdom of Great Britain and Northern Ireland asked on
DatabasesSQL
2 Comments1 Solution117 ViewsLast Modified:
Hi,
I am trying to import data from Excel 2016 into SQL Express Management Studio V 17.3
and coming up with the attached error message. I tried saving to an earlier version but
error saying that version was not suitable. I would like to get to the source of the
problem rather than a workaround solution. Earlier I tried the latest SQL version 18.0
but the import and export options were greyed out for some reason.
Any help much appreciated as I am pulling my hair out and not much of that left :)
Ian
SQL-Error-Message.png
ASKER CERTIFIED SOLUTION
lcohan
Database Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros