Excel driver on Azure Microsoft.ACE.OLEDB.12.0 error – Solution

If you are trying use the Excel Driver provided with Microsoft Access Database Engine 2010 Redistributable Click here to download and getting following message.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

So is it possible to have this driver on AZURE APP Service or web app?

Learn More about it https://azurefunctions.blogspot.com/2019/07/excel-in-azure-app-service-or-web-app.html

Sorry but answer is no? Click here to read the full Article

  • The error is by design as we do not install the Microsoft.Ace.OLEDB.12.0‘ driver.
    The Microsoft.Ace drivers are not supported in server side environments and there will be no plans to add these to the Azure Web Sites nor is it possible for you to add these.
    The supportability is discussed in the following articles.

Solution

Use Open XML SDK

Information about Open XML SDK

https://docs.microsoft.com/en-us/office/open-xml/how-to-parse-and-read-a-large-spreadsheet

Free Sample code using Open XML SDK

https://www.codeproject.com/Articles/670141/Read-and-Write-Microsoft-Excel-with-Open-XML-SDK

Open XML SDK Download if required

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

Leave a Reply

Your email address will not be published. Required fields are marked *