App Portal Error: The 'microsoft.ace.oledb.12.0' provider is not registered on the local machine

[#1]

Summary

This error will generally occur when trying to import from a .xsl document. This article provides a link to the Microsoft Access Database Engine, which is a required dependency

Symptoms

When attempting to import from a spreadsheet with App Portal, the following error is seen:


This article provides a link to the Microsoft Access Database Engine Redistributable, which is a required when importing data from a spreadsheet into App Portal

Resolution

The Microsoft Access Database Engine 2010 Redistributable can be downloaded from the following URL:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

Please download the 32-bit version of this redistributable, and install it on the server hosting App Portal.