We help IT Professionals succeed at work.

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

Ian Bell
Ian Bell asked
on
112 Views
Last Modified: 2020-11-13
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
Comment
Watch Question

Database Analyst
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Ian Bellretired

Author

Commented:
I reinstalled the program and wamp and that solved the problem
Thanks for your input