Access Datababase driver for Server 2016

Question

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!

Answer 1

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!

Answer 2

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

Answer 3

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--

Answer 4

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.

Answer 5

Hi @jon alderson ,

Is the reply helpful?

BR,
Mia

---

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