Developer forum

Forum » Hosting » Import/export to Excel on Azure server

Import/export to Excel on Azure server

Kim Hansen
Reply

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

image003.png

Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply
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
 
Dynamicweb Employee
Dmitriy Benyuk
Reply

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
Reply

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
Reply

Data Access Component worked perfectly, thanks :)

No need to restart.

 

You must be logged in to post in the forum