topic RE: OLEDB in Product Forum

OLEDB

Niteesh_ReddyBo — Fri, 17 Nov 2023 07:51:00 GMT

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
------------------------------

RE: OLEDB

michaeloneil — Fri, 17 Nov 2023 09:48:00 GMT

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
------------------------------

RE: OLEDB

Niteesh_ReddyBo — Fri, 17 Nov 2023 11:04:00 GMT

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
------------------------------

RE: OLEDB

harish.mogulluri — Mon, 20 Nov 2023 00:45:00 GMT

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
------------------------------