用ADO是这么连
Dim oCnn As New ADODB.Connection
Dim strLink As String
'连接数据库
strLink = "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=c:\;"
oCnn.CursorLocation = adUseClient
oCnn.Open strLink可用DAO该如何处理呢,谢谢了
Dim oCnn As New ADODB.Connection
Dim strLink As String
'连接数据库
strLink = "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=c:\;"
oCnn.CursorLocation = adUseClient
oCnn.Open strLink可用DAO该如何处理呢,谢谢了
打开纪录集的话就是mdbDatabase.OpenRecordset(文件名, dbOpenSnapshot)
strconnect可以是
strConnect = "Dbase III;"
strConnect = "Dbase IV;"
strConnect = "Dbase 5.0;"
strConnect = "FoxPro 2.0;"
strConnect = "FoxPro 2.5;"
strConnect = "FoxPro 2.6;"
strConnect = "FoxPro 3.0;"
要注意的是DAO3.6这种方法打不开FoxPro的dbf文件,DAO3.0可以