Download link for Microsoft.ACE.OLEDB.12.0

Question

We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required

Answer 1

Hi @Thomas Davies,

Thanks for your information.

I agree with Yitzhak Khabinsky. The Microsoft has removed the download link for the Microsoft.ACE.OLEDB.12.0.

This is the download link of Micrrosoft.ACE.OLEDB.16.0. https://www.microsoft.com/en-us/download/details.aspx?id=54920.

You can follow the steps in this article to import the excel files in SSMS. https://learn.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-ver16#wiz.

Hope this can help you well.

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications

Answer 2

Hi @Thomas Davies,

It seems that Microsoft removed a download link for the Microsoft.ACE.OLEDB.12.0

But you don't have to be stuck with it.

Here is your solution based on the newer Microsoft.ACE.OLEDB.16.0

In the SSMS import wizard just select Excel version: Microsoft Excel 2016

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

Answer 3

This answer may sound a bit twisted. ACE OLE DB 12 still works with SSIS 2019. Packages built with Visual Studio 2019 using ACE OLE DB 12 or an older, no longer supported and with breaking changes (ACE OLE DB 16) also, are no longer available (or supported). What is implied here is that builds correspond to MS Access which is now under the newer version supporting the Office 365. Once that occurred, and my ACE OLE DB 16 update began failing on my SSIS packages, I was able to revert back to ACE OLE DB 12 and keep them running. It would be great is Microsoft would allow us to download the older copies but it appears they've been destroyed. Probably rightly so, but to those of us who live behind a NAT that has no open ports, systems can still run on older files safely. My two cents.

Answer 4

The Wayback Machine and Internet Archive FOR THE WIN!

This was sourced from chocolatey, but is available for direct download from the following links:

32-bit: https://web.archive.org/web/20240214170634if_/https://download.microsoft.com/download/2/4/3/24375141-E08D-4803-AB0E-10F2E3A07AAA/AccessDatabaseEngine.exe

64-bit: https://web.archive.org/web/20240214170634if_/https://download.microsoft.com/download/2/4/3/24375141-E08D-4803-AB0E-10F2E3A07AAA/AccessDatabaseEngine_X64.exe Chocolately package for reference: https://community.chocolatey.org/packages/made2010#files