[Access 2003] [ADO Excel Connection] Run-time error '-2147217865 (80040e37)'

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+] [0]$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 Forums3

Hi Perry,

It's your range thats causing the error, if you run with only the sheet name then it's fine but when you add the range A7:BB65536 the error is thrown. Have you tried using a named range instead Named ranges are treated like tables in the workbook.