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





PostPosted: Visual Basic for Applications (VBA), [Access 2003] [ADO Excel Connection] Run-time error '-2147217865 (80040e37)' Top

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  
 
 
Derek Smyth





PostPosted: Visual Basic for Applications (VBA), [Access 2003] [ADO Excel Connection] Run-time error '-2147217865 (80040e37)' Top

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.