Data Reader - Read From Excel - Microsoft.ACE.OLEDB.12.0 - Error

  • 669 Views
  • Last Post 26 March 2018
Varsha posted this 09 January 2018

Hi,

How can I fix the below error:

      

      

  

Deepak posted this 26 March 2018

Hi,

Thanks for contacting the Intellibot support team.

To fix the Data Reader | ReadFromExcel | AutxDataReader | Microsoft.ACE.OLEDB.12.0 error:

You need to download and install a set of components that can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications.

Please click the link below:

      Microsoft Access Database Engine 2010 Redistributable

 

Note: There are multiple files available for this download. Once you click on the "Download" button, you will be prompted to select the files you need.

  • Select AccessDatabaseEngine.exe

     

This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server. Connectivity to existing text files is also supported. ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats. 

 

Installation Instructions:

Note: Before installing this download, you must first remove any previous versions of the Access Database Engine from your computer by using Add/Remove Programs in the Control Panel. 

To install this download:

  1. Download the file by clicking the Download button and saving the file to your hard disk.

  2. Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.

  3. Follow the instructions on the screen to complete the installation.

 

Please note, changes to fix this error won't take effect until you relaunch the Intellibot Studio.

Have a nice day.

Thank you.

--
Regards,
DEEPAK

Close