Link to home
Start Free TrialLog in
Avatar of Ian Bell
Ian BellFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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

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 :)
Avatar of lcohan
Flag of Canada image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ian Bell


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