Ian Bell
asked on
oledb.16.0 provider is not registered on this machine error message
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your input