I use excel driver to retrieve the data (not allowed to use excel object
libaray), the worksheet name seems cannot contain any space(ie. "worksheetname"
but not "worksheet name") . Is this can be solved ?

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel
8.0;HDR=Yes;IMEX=1';Data Source=........"

cn.CursorLocation = adUseClient

sSQL = "select * from ['worksheetname$'A1:B10]"

rs.Open sSQL, cn


THANKS ALL~~~