OLEDB Usage

[varshakanthikar]

Hi ,
I had gone through OLEDB Guide provided by blue prism Portal. While setting Connection I am getting error as "could not execute code stsge because exception thrown by code stage: format of the initializing string does not confirm to a specification starting index 152"

I Provided connection string as "

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="D:\Blue Prism\Business Planning and operations\Pipeline Tracker Base Creation\TSU-Pipeline-Tracker.xlsx";Extended Properties="Excel 12.0 Xml;HDR=YES;"

still not able to set connection using data-OLEDB VBO

Thanks and Regards,
Varsha Kanthikar

------------------------------
varsha kanthikar
project trainee
persistent systems limited
America/Indiana/Indianapolis
------------------------------

[gmarquez]

Hi Varsha,

This usually points to an error with your connections string. From our documentation, I think you need to remove the XML in extended properties and add Extended Properties - Extended Properties="Excel 12.0;HDR=YES;"; From here: http://portal.blueprism.com/customer-support/support-center#/path/1416707612

Once you reconfigure your connection string, make sure to test it outside of Blue Prism to make sure it works correctly.

I hope that helps!

------------------------------
Gabe Marquez
Technical Support Engineer
Blue Prism
------------------------------