Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selecting rows from Excel
Message
De
23/11/2000 16:26:40
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Québec, Canada
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Selecting rows from Excel
Divers
Thread ID:
00445068
Message ID:
00445068
Vues:
45
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
Fil
Voir

Click here to load this message in the networking platform