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

  • Question

  • I am using VS2019 VBA and attempting to import an excel spreadsheet. It is bombing off on this line and giving me the error that The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine'. I recently had my laptop re-imaged so I am assuming it is missing something but not sure what. Thanks.

    Dim ExcelStringNm As String = "Provider=Microsoft.ACE.OLEDB.16.0;" &
                           "Data Source=" & JobCodeRptPath & ";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"""

    Wednesday, October 30, 2019 7:24 PM

All replies

  • Hi J-Bal,

    Welcome to MSDN forum.

    According to your description, I might need to confirm something from you. Which version of Excel do you use?

    I suggest you could download Microsoft Access Database Engine 2016 Redistributable to check if your issue could be solved.

    In addition, according to this similar issue, not sure if it is helpful, you might could refer to this sentence “Whatever file you are trying to import, make sure you select it as an Office 2010 file(even though it might be an Office 2016 file)”

    Any feedback will be expected.

    Best Regards,

    Tianyu


    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.

    Thursday, October 31, 2019 6:18 AM
  • I am using Microsoft Excel for Office 365 MSO 16.0.10730.20264 32 bit.

    Thursday, October 31, 2019 5:02 PM
  • I tried installing the MS Database Engine and still go the same result.
    Thursday, October 31, 2019 7:27 PM
  • Hi J-Bal,

    Thank you for the feedback.

    You could also try below steps to troubleshoot.

    #1. Make sure that you download and install “AccessDatabaseEngine.exe” instead of “AccessDatabaseEngine_X64.exe”.

    #2. Try to avoid side by side affection if there is any error when you download the “AccessDatabaseEngine_X64.exe” and “AccessDatabaseEngine_X64.exe” then try to install the second one.

    >> open command prompt as administrator then provide the installation path and switch Ex: C:\Files\AccessDatabaseEngine_X64.exe /quiet.

    #3. Use an earlier one may be helpful, you could try to download and install this Microsoft Access Database Engine 2010 Redistributable.

    Hope this could help you.

    Best Regards,

    Tianyu


    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.

    Friday, November 1, 2019 9:19 AM
  • Hi J-Bal,

    You could try this connection string,

    Dim str As String = "Provider = Microsoft.ACE.OLEDB.12.0;" & "Data Source=" & JobCodeRptPath & ";" & "Jet OLEDB:Engine Type=5;" & "Persist Security Info=False;Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1""".

    If it persists, please try to delete Extended properties = "...", then check if it could work. 

    Look forward to your feedback.

    Best Regards,

    Dylan


    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


    Friday, November 1, 2019 9:36 AM