Blog

Dataverse - Excel Import - How to fix Microsoft ACE OLEDB 12.0 Error

When we attempt to import an Excel spreadsheet from OneDrive to Dataverse, we may encounter a 'Microsoft.ACE.OLEDB.12.0' error message. This post describes a fix for this issue.

A common task is to import an Excel spreadsheet into a new or existing Dataverse table.

The typical way to carry out this task is to upload the source Excel file into "OneDrive for Business", and to choose the "Get data" item from the Data menu of the Maker Portal.


We attempt to choose our source spreadsheet, we may encounter the following error:

An exception occurred: DataSource.NotFound: Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987. (Session ID: 6fea006f-20c6-48d0-89b5-742688cf034c)



This can be a confusing error, and following the instructions to download the client software will not help.

The most common cause of this problem is that the source spreadsheet is in Excel XLS format (e.g., the Excel file format for Excel versions 97-2003).

This import process does not work with the older Excel file format. Therefore, if we save the spreadsheet in XLSX format and re-attempt the import process, it will most likely work.

Conclusion

If we encounter errors when we attempt to import Excel data in Dataverse, a first step is to make sure that we've saved the file using the latest Excel file format. If the import process still fails, copying and pasting the data into a new spreadsheet may help. If this still fails, reducing the number of rows in the source spreadsheet can help diagnose the cause of the problem.
Previous
Next
Related posts