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

  • Question

  • I am running Office 365 64 bit and SQL Server 2016 with SSMS 2017 18.3 64 bit  with Windows 10 64 bit I have got the message when trying to import an excel file.  I have tried running the Access Engine 64 bit but tells me I have 32 bit office products installed and to uninstall them.  How can I identify these?
    Tuesday, September 24, 2019 10:25 AM

All replies

  • I am running Office 365 64 bit and SQL Server 2016 with SSMS 2017 18.3 64 bit  with Windows 10 64 bit I have got the message when trying to import an excel file.  I have tried running the Access Engine 64 bit but tells me I have 32 bit office products installed and to uninstall them.  How can I identify these?

    Did you try to install both 32/64 bit from below? Below is 2016 Redistributable.

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


    Cheers
    Vaibhav
    MCSA (SQL Server 2014)

    Tuesday, September 24, 2019 10:35 AM
  • SSMS 2017 18.3 64 bit 

    SSMS is a 32 bit application and when you start the Import/Export wizard from SSMS, then it starts the 32 bit Version and that one can only utilize 32 bit data Provider.

    Start the wizard from start menu or install (additional) the 32 bit ACE Provider.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, September 24, 2019 10:51 AM
  • When I ran it from the start menu there was no option for Excel
    Tuesday, September 24, 2019 12:02 PM
  • Hi soundsimpossible,

     

    >>I am running Office 365 64 bit and SQL Server 2016 with SSMS 2017 18.3 64 bit  with Windows 10 64 bit I have got the message when trying to import an excel file. 

     

    SSMS is only 32-bit, so the import and export wizard on SSMS is also 32-bit. Since your excel is 64-bit, you must also use the 64-bit import and export wizard, please  use SQL Server 2016 Import and Export Data (64-bit) (Under the Microsoft SQL Server 2016 folder in the start menu bar)to import your excel file:

     

     

     

    The one below is 64-bit and the one above is 32-bit.

     

    Best regards,

    Dedmon Dai


    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, September 25, 2019 1:50 AM
  • I am running Office 365 64 bit and SQL Server 2016 with SSMS 2017 18.3 64 bit  with Windows 10 64 bit I have got the message when trying to import an excel file.

    Hi soundsimpossible,

    Please elaborate how exactly you are trying to import an Excel file

    There are few way to do it. We need to know that before we can suggest any solution.

    Wednesday, September 25, 2019 4:32 AM