FW_OpenAdoExcelSheet with error ADO ERROR - Solved

Post Reply
User avatar
Maurizio
Posts: 826
Joined: Mon Oct 10, 2005 1:29 pm
Contact:

FW_OpenAdoExcelSheet with error ADO ERROR - Solved

Post 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
Last edited by Maurizio on Wed Jun 30, 2021 3:30 pm, edited 1 time in total.
User avatar
nageswaragunupudi
Posts: 10721
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 8 times
Contact:

Re: FW_OpenAdoExcelSheet with error ADO ERROR

Post 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.
Regards

G. N. Rao.
Hyderabad, India
User avatar
Maurizio
Posts: 826
Joined: Mon Oct 10, 2005 1:29 pm
Contact:

Re: FW_OpenAdoExcelSheet with error ADO ERROR - Solve

Post 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
Post Reply