OLEDB Issue

[AmySnagg]

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

[Babjee24]

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

[Athiban_Mahamathi]

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