I'm trying to get ADO to work with Excel tables. the following code represents my connetion open:

Call cnADO.Open("Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"DBQ=" & strDbName & ";")

(Using the 97/2000 ODBC driver)

Now, that all works fine, but when I go to pull the data in like so:

Call rsResult.Open("SELECT * FROM xl_sheet, cnADO)

xl_sheet is a sheet in the xls file

it blows up with this msg:

[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object 'xl_sheet'. Make sure the object exists and that you spell its name and the path name correctly.

I would be greatful of any insight to this problem.

thanks