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

p.pilat@nsi-sa.be'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.