problem in connecting to winsql
 

After defining the data source, the driver and the worksheet to be queried
for excel files in Winsql, i am not able to run the query.

i am getting and error

Error: The Microsoft Jet database engine could not find the object 'book1'.
Make sure the object exists and that you spell its name and the path name
correctly. (State:S0002, Native Code: FFFFFAE7)

where book1 is the workbook selected...
Plz tell me how the query is executed

--
Message posted via http://www.officekb.com