Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing

Waktu meng-import excel pada Sql Server Management Studio, muncul error

The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

Solusinya meng-install Microsoft.ACE.OLEDB.12.0

Download: https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

Untuk meng-install di Windows Server 64 bit, perlu menggunakan command prompt

Panggil installer dengan parameter /passive, seperti gambar di bawah ini:

https://datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/