Forum management
- Threads started by me
- Threads I participate in

Developer forum

Import/export to Excel on Azure server

E-mail notifications

Kim Hansen

Posted on 10/06/2020 18:49:34

Hi,

We have moved a customers solution from their own server to an Azure server.

Everything is working fine, exept when the customer want to import or export to Excel.

Then they get the error The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

What am i missing?

/Kim

Replies

Nicolai Pedersen

Posted on 11/06/2020 08:59:41

This post has been marked as an answer

Is it a webapp or azure vm?

If it is a webapp you cannot do anything about it. We need to change to use a more recent technology supported on that stack.

If it is an Azure VM I believe you can install the Data Access Component on the server: https://www.microsoft.com/en-us/download/details.aspx?id=13255

Votes for this answer: 1

Dmitriy Benyuk

Posted on 11/06/2020 12:53:40

Hi Kim,
could you try with "*.xls" files only? That should probably work if you have 32 bit environment, and will probably not work for 64. The *.xls extension should use the Microsoft.Jet.OLEDB.4.0 driver.
Kind regards, Dmitrij

Kim Hansen

Posted on 11/06/2020 13:45:58

Nicolai: Its an Azure VM, and ill try the Data Access Component tonight when the server is a bit more empty :) Thanks

Dmitriy: As far as i know, Azure is native 64-bit.. and i think ill get killed by our Hosting department if i changed it to 32-bit.

Kim Hansen

Posted on 11/06/2020 23:08:11

Data Access Component worked perfectly, thanks :)

No need to restart.

Justin Sjouw

Posted on 29/09/2022 10:28:02

One addition for people also needing to install the Microsoft.ACE.OLEDB.12.0, use the x64 version! :-)

You must be logged in to post in the forum