topic RE: OLEDB Issue in Product Forum

OLEDB Issue

AmySnagg — Wed, 02 Aug 2023 11:42:00 GMT

Hi,

I am having some trouble when I am trying to read a file using oledb. I keep getting an error message saying Failure Creating File (see image below). This is happening on the open stage and sometimes on the get collection stage.

My connection string looks like this and I change <INPUT> to my file path which is an xlsb file due to the size of the document being 290,000 rows.

In my get collection stage I am using "SELECT * FROM [Worksheet Name] WHERE [Column Name] ='Unique Value'" where worksheet name, column name and unique value will all be changed to match the data I want to pull.

I was just wondering if anyone might have any ideas or solutions on how to fix this please 🙂

Many thanks,

Amy

------------------------------
Amy Snagg
------------------------------

RE: OLEDB Issue

Babjee24 — Wed, 02 Aug 2023 18:25:00 GMT

Hi Amy,

Remove the double quotes for Data source file path. Have the entire connection string in a text data item instead of directly passing it as quote issues occur while setting up the connection.

------------------------------
Babjee Vangipurapu
Senior RPA Developer
Wonderbotz
India
------------------------------

RE: OLEDB Issue

Athiban_Mahamathi — Thu, 03 Aug 2023 03:44:00 GMT

Hi Amy,

Are you trying to connect to the XLSB file located in SharePoint or Local?

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------