64 bits executable and accessing Excel data

1
0
-1

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 :

<code snippet>

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

 

TIA

Best regards.

Question Tags: 

Answers

Chris Pollach answered 64 bits executable and accessing Excel data

1
0
-1

Hi Philippe;

  Correct, the OLE interface is not yet supported in 64bit mode in PB 2017.

Have you tried using ODBC instead over to Excel?

Regards ... Chris

Philippe PILAT's picture

Hi Chris,

Thank you for your prompt answer. It works with ODBC (both 32 & 64 bits).

You say "not yet supported", do you have any idea of when it will be supported.

 

Best regards,

Philippe.