Extracting data from txt file using OLEDB - issues

cvmac — Thu, 09 Nov 2023 17:05:00 GMT

Hello,

I am trying to extract data from a large txt file but getting errors suggesting access is an issue but I am able to access contents via PowerQuery so access cannot be the issue.

Set Connection string is:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\cefil0520\GLEAM\Gleam_MI;Extended Properties="text;"

Get Data Collection OLEDB action using input parameter:

Select [POLICYNUMBER], [POSTCODE], [LONGITUDE], [LATITUDE], [ADDRESS], [MATCH_LEVEL], [COUNTRY_CODE] FROM [ZURICHUKMI_PolicyRisk_20231106_161444] where [POLICYNUMBER] like '%QLA-10U005-0013%'

I am receiving this error:

Could not execute code stage because exception thrown by code stage: The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.

Is there something I should change about the inputs to resolve error?

------------------------------
Chloe MacIntosh
Automation Developer
Zurich Insurance
Europe/London
------------------------------

RE: Extracting data from txt file using OLEDB - issues

John__Carter — Mon, 13 Nov 2023 09:12:00 GMT

The error suggests something else has the file locked, so check if that is a user, including yourself. Maybe it's some other application - you mentioned PowerQuery. And maybe it's a connection you previously created by running BP, so restart BP to release.

------------------------------
John Carter
Blue Prism
------------------------------

topic Extracting data from txt file using OLEDB - issues in Product Forum

Extracting data from txt file using OLEDB - issues

RE: Extracting data from txt file using OLEDB - issues