Unable to Show Data Tables in Excel Data Source

The scenario is applicable for Test Studio versions before release 2024 Q1 (2024.1.220).

If running a data driven test on remote machine you get your test failed and the following exception could be found in the log:

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

This could happen on machines with no Microsoft Office or Data Connectivity Component installed or if the Microsoft Office package is 64-bit version.

Another option to face the same error in the application log is to bind an Excel file to a test, and try to select a sheet - the list is empty.

No sheets

Solution

Download and install the 32-bit version of Microsoft Access Database Engine 2010. It will install the required drivers for communication between Test Studio and the Microsoft Office files for all of the above cases.

In this article

Not finding the help you need?

Contact Support

Improve this article

Getting Started

Community

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.

DO NOT SELL MY PERSONAL INFORMATION