Extracting data from txt file using OLEDB - issues

[ChloeMacIntosh]

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

[John__Carter]

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