Error clause when retrieve data from Excel file using ADO, error message as the following:
ShtName = "'AA BB CCCCC DD(EEEEEEE$00+) (0)"
strSQL = "Select * From [" & ShtName & "$A7:BB65536]"
Run-time error '-2147217865 (80040e37)':
The Microsoft Jet database engine could not find the object
'AA BB CCCCC DD[EEEEEEE$00+] $A7:BB65536'.
Make sure the object exists and that you spell its name and the path name correctly.
Thank you very much!
Microsoft ISV Community Center Forums1