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 ?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only