Share via

The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

Anonymous
2022-08-20T19:55:17+00:00

This pops up as soon as I try to connect and import the data from excel workbook to the sql server. shoot in some help. Thanks.

Moderator note < moved from windows category >

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2023-01-09T15:18:29+00:00

    https://www.youtube.com/watch?v=brGq2by7DvA

    ☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️

    Checkout this video, it really works!!!!!!!

    For those who don't want to watch the video. The solution is to install the 32 bit Access Database Engine. But Windows won't allow you to do this saying you already have the 64 bit version installed, so to workaround this run the installer with the /quiet flag.

    accessdatabaseengine.exe /quiet

    Then it should work immediately, no need to restart anything.

    300+ people found this answer helpful.
    0 comments

32 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-19T19:52:34+00:00

    Thanks Robinson, I have same problem and have Access installed already as part of Office 365, and it's still not working

    Anybody knows if anything else could be changed

    V

    20+ people found this answer helpful.
    0 comments
  2. Anonymous
    2022-08-20T23:25:41+00:00

    Hi, I'm Robinson, and I’m happy to help you today.

    This error indicates that the Microsoft Access Database Engine 2016 is not installed, download and install the Microsoft Access Database Engine from this link should fix this problem.

    https://www.microsoft.com/en-us/download/detail...

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2022-10-23T05:05:33+00:00

    i cannot export my Excel file to SQL

    10+ people found this answer helpful.
    0 comments
  4. Anonymous
    2022-11-04T11:36:09+00:00

    i cannot export my Excel file to SQL

    INSTEAD OF INSTALL "Microsoft Access", I WOULD SUGGEST CONVERT YOUR 'EXCEL' FILE INTO 'CSV' FORMAT AND TRY TO ADD THAT CSV FILE AND WORK ON IT. IT'S REALLY VERY HELPFUL.

    7 people found this answer helpful.
    0 comments