hi,

Despite MS said that ExcdlADO should be reference in the following format:

strSQL = "SELECT * FROM [Sheet1$B1:C20]"

But you should also try:

strSQL = "SELECT * FROM [DATABASE$B1:C20]"

where DATABASE is the name of Sheet9. I don't know how I have programmed,
(Using Jet database), but I couldn't get the 1st scenario working, and got
the following Run-time error:

Run-time error '-2147217865 (80040e37)':
The Microsoft Jet Database could not find the object 'Sheet1$B1:C20'. Make
usre the object exists and that you spell its name and the path correctly.

If someone know about what cause this behaviour, please let me know.

Regards
Augustus