Page 1 of 1

FW_OpenAdoExcelSheet with error ADO ERROR - Solved

Posted: Wed Jun 30, 2021 9:34 am
by Maurizio
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

Re: FW_OpenAdoExcelSheet with error ADO ERROR

Posted: Wed Jun 30, 2021 2:34 pm
by nageswaragunupudi
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.

Re: FW_OpenAdoExcelSheet with error ADO ERROR - Solve

Posted: Wed Jun 30, 2021 3:30 pm
by Maurizio
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