Access Datababase driver for Server 2016

jon alderson 96 Reputation points
2020-11-04T16:54:08.493+00:00

I have a user who is trying to create an automated process to import Excel data into a SQL database. When she does this she receives an error stating to reinstall the Microsoft Data Access Components. I have installed the OLE DB driver 18 but this did not work. Is there any way to get the Microsoft Access Data Components installed on Server 2016? Thank you for any feedback!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,785 questions
0 comments
Accepted answer
  1. jon alderson 96 Reputation points
    2020-11-09T19:07:05.857+00:00

    Thank you for all your suggestions. I did notice that the suggested fixes did not list Server 2016 as a supported OS. Have any of you had issues or direct experience installing Microsoft.ACE.OLEDB.16.0 on a 2016 server? I just want to be careful as this is a production server. Thank you!

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 25,856 Reputation points
    2020-11-04T20:28:02.097+00:00

    Hi @jon alderson ,

    The Microsoft ACE OLEDB provider is exactly what you need while dealing with the MS Excel files.
    It has two editions: 32-bit and 64-bit. And 3 versions, you would need just any one of them:

    Microsoft.ACE.OLEDB.12.0
    https://www.microsoft.com/en-us/download/details.aspx?id=13255

    Microsoft.ACE.OLEDB.15.0
    https://www.microsoft.com/en-us/download/details.aspx?id=39358

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

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-11-04T17:03:55.98+00:00

    Access is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access
    https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments
  3. m 4,271 Reputation points
    2020-11-05T02:14:39.62+00:00

    Hi @jon alderson ,

    Solution as next:
    Please reference: sql-server-fix-export-error-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine

    Download here: Microsoft Access Database Engine 2010 Redistributable and then install it ,the issue will be solved.

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  4. m 4,271 Reputation points
    2020-11-06T01:34:58.167+00:00

    Hi @jon alderson ,

    Is the reply helpful?

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.