sorry, i wasn't clear enough. yes, i know. this code works just fine in access
Dim cConnectString, oRS As ADODB.Recordset, oConn, cString As String
cConnectString = "Provider=VFPOLEDB.1;Data Source=c:\Archivos de programa\Microsoft Visual FoxPro 8\Samples\Data\testdata.dbc;" & _
"Mode=ReadWrite|Share Deny None;Password='';Collating Sequence=MACHINE"
Set oConn = CreateObject("ADODB.Connection")
oConn.ConnectionString = cConnectString
oConn.ConnectionTimeout = 30
oConn.Open
cSQL = "select * from customer"
Set oRS = oConn.Execute(cSQL)
now, the question is how do i link that table (customer) in a ms access database using the vfpoledb provider. is that even possible ?
Précédent
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