image-2

How to Fix The “Microsoft.ACE.OLEDB.16.0 Provider is not registered on the local machine.”

A popular issue in importing the data which is in Microsoft Excel 2016 to MSSQL via SSMS (Management Studio). It throw an error : “=================================== The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data) To fix this, First thing first, install “Microsoft Access Database Engine 2016 Redistributable.” https://www.microsoft.com/en-us/download/details.aspx?id=54920 And then also check the Read More