ODBC connection string

[ZdeněkKabátek]

Hi,

how the ODBC connection string should be built in Validation list? I would like to connect to excel. There is an example for SQL database but not for excel.

Thanks.

Regards

Zdenek

[michaeloneil]

Hi Zdenek 

Im guessing you are referring to within excel​ rather than through blue prism? I've never used this before but there are a couple of connection strings for excel which you can try.

if the File extension is .XLS using below connection string
//In following sample 'szFilePath' is the variable for filePath
Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + szFilePath + ;Extended Properties=\"Excel 8.0;HDR=YES;\"";

// if the File extension is .XLSX using below connection string
szConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;
"Data Source='" + szFilePath +
"';Extended Properties=\"Excel 12.0;HDR=YES;\"";

[ZdeněkKabátek]

Hi, Michael,

well, I was not completely clear probably but the question is related to Decipher and Validation Lists.

Regards

Zdenek