the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine

You may receive this error when you want to import data from a file such as Excel to the sql server. You must install the Microsoft Access Database Engine 2010 Redistributable on the server that has SQL Server installed as the solution.

You can download and install from the link below.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

If the server you are installing is 64-bit, you must download the 64-bit version. You can write msinfo32 to run if your server’s operating system is 64-bit. If you see x64 in system type, you are using 64 bit operating system.