HI,
I have a spreadsheet that contains data. I need to import these data into an ADO Recordset in order to manipulate them. I use a DSN-LESS connection such as :

oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"Dbq=" & Txtpath.Text & ";"

The connection seems to be ok but when I try to retreive some rows form the spreadsheet :

oRs.Open "SELECT * FROM" & txpath.text, oConn, adOpenStatic, adLockReadOnly, adCmdText

I get an error that tells me that it cannot find the database or datasource.

How can I retreive the rows form my spreadsheet ?

Thank you,
Christian