My application is developed in PB 12.5 and migrated successfully to PB 2017. However there is a functionality to upload Excel files into a SQL Server DB. The code is :
ltr_excel = CREATE TRANSACTION
ltr_excel.DBMS = "OLE DB"
ltr_excel.AutoCommit = TRUE
ltr_excel.DBParm = "PROVIDER='Microsoft.ACE.OLEDB.12.0', DATASOURCE='" + ls_dir + "',PROVIDERSTRING='Excel 12.0; MaxScanRows=0;HDR=Yes;IMEX=1'"
CONNECT USING ltr_excel;
<end of code snippet>
Works perfectly in 32 bits but in a 64 bits exe, fails : "DBMS OLE DB is not supported in your current installation."
I understand that there is no 64-bit version of the PBOLE database interface but can you suggest another way to do it (which works in 32 and 64 bits) ?