Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Selecting rows from Excel
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement