locked
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine RRS feed

  • Question

  • Hello,

    I am using SQL Server 2014 and also SQL Server 2019. I have installed both Miscrosoft Access Database Engine 2010 and 2016 Redistributable to my computer.  Dynamic Parameter and Allow Inprogress are both enabled. However, my Server still show following errors when I tried to import or export excel xlsx file.

    If anyone know the solution, please help. Thank you.

    Errors:

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

    The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine

    Friday, October 2, 2020 10:51 PM

All replies

  • Hi BingZL,
    For questions about SQL Server, it is recommended to go to SQL Server forum for professional answer.
    Thank you for your understanding.
    Best Regards,
    Daniel Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, October 7, 2020 1:33 AM