We now have a pro license and i attempted to import from an Excel spreadsheet and got the message that an additional Microsoft Office driver is required from this page http://www.microsoft.com/download/en/confirmation.aspx?displayLang=en&id=23734. This has now been installed on the server hosting the Umbraco website however I am still getting the same error message. Anybody got any ideas on how to fix this?
Hi Richard, I have recycled the application pool but I am still getting the same message when selecting and Excel file that I need to download and install a driver from Microsoft. Any other ideas? I've tried on my workstation and it works, the difference being it is running on a 32 bit OS whereas the development and UAT sites are running on a 64 bit server. Not sure if this would cause a problem?
IIS 7 will not by default serve 32-bit apps, which is what the database engine operates on so you need to go into the app pools advanced settings and change the Enable 32-bit Applications property to true and then recycle the app pool.
I have the same problem, but am running on IIS 6, 32 bit. Iäve restarted the application pool but still the same message. I've restarted my computer, tested in different browsers etc. Still the same message....
The latest binaries are using a different Excel provider to avoid this issue and include several other fixes. You find the binaries on http://hotfix.soetemansoftware.nl/CMSImport/ Replace them with the ones in your bin folder and you should be fine.
Excel import failing
We now have a pro license and i attempted to import from an Excel spreadsheet and got the message that an additional Microsoft Office driver is required from this page http://www.microsoft.com/download/en/confirmation.aspx?displayLang=en&id=23734. This has now been installed on the server hosting the Umbraco website however I am still getting the same error message. Anybody got any ideas on how to fix this?
Hi Andy,
First of all thanks for the purchase. I think this can easily be fixed by restarting your application pool running the website.
Cheers,
Richard
Hi Richard, I have recycled the application pool but I am still getting the same message when selecting and Excel file that I need to download and install a driver from Microsoft. Any other ideas? I've tried on my workstation and it works, the difference being it is running on a 32 bit OS whereas the development and UAT sites are running on a 64 bit server. Not sure if this would cause a problem?
Managed to solve it by checking the Umbraco logs for the error message which led me to this Stackoverflow Q/A http://stackoverflow.com/questions/238625/microsoft-ace-oledb-12-0-provider-is-not-registered.
IIS 7 will not by default serve 32-bit apps, which is what the database engine operates on so you need to go into the app pools advanced settings and change the Enable 32-bit Applications property to true and then recycle the app pool.
Hi Andy,
Great that this issue is solver. I can confirm that you need 32 bits enabled.
Cheers,
Richard
Yes, it does seem you need this app pool property enabled for this to work with IIS 7 on a 64 bit server.
I have the same problem, but am running on IIS 6, 32 bit. Iäve restarted the application pool but still the same message. I've restarted my computer, tested in different browsers etc. Still the same message....
Hi Frederik,
The latest binaries are using a different Excel provider to avoid this issue and include several other fixes. You find the binaries on http://hotfix.soetemansoftware.nl/CMSImport/ Replace them with the ones in your bin folder and you should be fine.
Thanks,
Richard
Thanks, you kick ass :)
Richard, do the latest binaries allow CMSImport to work with Excel spreadsheet with 32 bit mode enabled in the app pool?
No either 64 bits or 32 it's up to you, using a third party component now. Hope to release it very soon in an official release.
is working on a reply...