TestComplete displays this message when it is trying to read data from a CSV or an Excel file and cannot find the required data source driver.
64-bit TestComplete
To read CSV and Excel files, 64-bit TestComplete requires the 64-bit version of the Microsoft Office 12.0 Access Database Engine OLE DB Provider.
To get the Provider, install Microsoft Access Database Engine 2010 Redistributable x64 on your computer. You can download it on the Microsoft website:
https://www.microsoft.com/en-us/download/details.aspx?id=13255
![]() |
If you have 32-bit Microsoft Office 2010, the installation of the 64-bit provider will fail. In this case, perform the following steps to install it: |
32-bit TestComplete
To read Excel 2007 - 2016 files, TestComplete x86 requires the 32-bit version of the Microsoft Office 12.0 Access Database Engine OLE DB Provider. You can get the provider as part of the following software:
-
Microsoft Access Database Engine 2010 Redistributable. Available for downloading from the Microsoft website:
https://www.microsoft.com/en-us/download/details.aspx?id=13255
-
32-bit version of Microsoft Office Excel 2007 - 2016.
-
2007 Office System Driver: Data Connectivity Components. You can download them on the Microsoft website:
https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734
To read Excel files created with Excel 2003 and earlier, as well as to read data from CSV files, 32-bit TestComplete uses the Microsoft Jet Engine driver. It is installed in the Windows operating system by default.
See Also
Using Excel Files as Data Storages
Using CSV Files as Data Storages
Variables of the DB Table Type