topic Re: ODBC connection string in Product Forum

ODBC connection string

zdenek.kabatek — Mon, 12 Sep 2022 08:58:07 GMT

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

Re: ODBC connection string

michaeloneil — Tue, 13 Sep 2022 15:49:04 GMT

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;\"";

Re: ODBC connection string

zdenek.kabatek — Wed, 14 Sep 2022 06:46:52 GMT

Hi, Michael,

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

Regards

Zdenek