I am working with MS Excel files in my web application built in Azure environment. I never run into following error when I am trying to access the excel file on my development fabric. But once I deploy to Azure in cloud, I get this error message.
The 'Microsoft.ACE.OleDb.12.0' provider is not registered on the local machine.
I was under impression that development fabric for Azure is replica of the environment you would expect in Cloud.
Is there something wrong I am doing here? Is ACE.OleDb provider not present in Azure?
The development fabric is a simulation of the Azure cloud - not a replica. It is possible there is software installed on your development machine that is not available in an Azure VM - such as Office. I believe 'Microsoft.ACE.OleDb.12.0 ships with
Marked As Answer byS IMonday, October 18, 2010 11:24 PM
If you only need to work with Excel 2007 formats or later (xlsx), you can use the
OpenXml SDK. This SDK requires installation on your local machine. But you can simply reference the DocumentFormat.OpenXml.dll assembly in your Web/Worker Role, and set Copy Local to true. It will work in the cloud. It also doesn't require Office to be
installed on the cloud machine.
But if you need to work with older versions (the binary xls format), I'm not aware of any SDKs that do not rely on Office.
Lante, shanaolanxing This posting is provided "AS IS" with no warranties, and confers no rights.
Marked As Answer byS IMonday, October 18, 2010 11:23 PM