OLEDB

[Niteesh_ReddyBo]

Hello,

When I am using OLEDB action I am getting error like 'Could not find installable ISAM' did anyone knows the solution for this kind of error. Thanks in advance.

------------------------------
Niteesh Reddy Bollu Senior Software Engineer
Lead Assistant Manager
exl service.com (India) Pvt. Ltd.
Gurgaon
9741235369
------------------------------

[michaeloneil]

Hi @Niteesh_ReddyBo

What is it you are trying to connect to, is it an excel file? If its excel/access then it could be a compatibility issue you can find more info on this error here "Could not find installable ISAM" error when you refresh a data table in Excel - Microsoft Support

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

[Niteesh_ReddyBo]

Hi...Thanks @Michael ONeil. I got it resolved. Earlier I mistyped my connection string as Provider.Microsoft.ACE.OLEDB.12.0;Data Source={{file_name}};Extended Properties="Excel 12.0 Xml;HDR=YES"; . Now I corrected it to Provider=Microsoft.ACE.OLEDB.12.0;Data Source={{file_name}};Extended Properties="Excel 12.0 Xml;HDR=YES";

------------------------------
Niteesh Reddy Bollu Senior Software Engineer
Lead Assistant Manager
exl service.com (India) Pvt. Ltd.
Gurgaon
9741235369
------------------------------

[harish.mogulluri]

Hi niteesh,

It looks like either the file path is invalid or the required driver is not installed.

Check below knowledge base article from blue prism.

https://support.blueprism.com/en/support/solutions/articles/7000078395-bpe-error-could-not-find-installable-isam-error-when-using-data-oledb-to-get-collection-from-an-exc

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------