FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour FW_OpenAdoExcelSheet with error ADO ERROR - Solved
Posts: 842
Joined: Mon Oct 10, 2005 01:29 PM
FW_OpenAdoExcelSheet with error ADO ERROR - Solved
Posted: Wed Jun 30, 2021 09:34 AM

Hello

I use FW_OpenAdoExcelSheet and on some PC (with same version of Office) I have this error

ADO ERROR UNKNOWN

what can cause this error ?

FW February 2021

Maurizio

Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: FW_OpenAdoExcelSheet with error ADO ERROR
Posted: Wed Jun 30, 2021 02:34 PM

Please make sure Microsoft.ACE.OLEDB provider is downloaded and installed on the PC.
Also, make sure you provide that the excel file name is given with full path and really exists before you call the function.

Regards



G. N. Rao.

Hyderabad, India
Posts: 842
Joined: Mon Oct 10, 2005 01:29 PM
Re: FW_OpenAdoExcelSheet with error ADO ERROR - Solve
Posted: Wed Jun 30, 2021 03:30 PM

Grazie RAO

I had to install Microsoft.ACE.OLEDB 32 bit, on some pc there was 64bit

https://datasavvy.me/2017/07/20/install ... rocessing/

Maurizio

Continue the discussion