如何连接foxpro2.5的.dbf？

[zbboy80]

用DATA控件出现错误：Could not find installable ISAM.请问怎么回事？

[online]

安装mdac2.6试试
有OLEDB for foxpro

[zjcxc]

'引用:Microsoft ActiveX Data Objects 2.1 Library
'win98第二版及以后的版本里不用安装任何东西

Sub fox()
Dim iRe As ADODB.Recordset
Dim iConc As String

iConc = "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=""DSN=Visual FoxPro Tables;UID=;SourceType=DBF" & _
";SourceDB=f:\My Documents"""

Set iRe = New ADODB.Recordset
iRe.Open "select * from [aa.dbf]", iConc, adOpenKeyset, adLockOptimistic

MsgBox iRe.Fields(0)
End Sub

[lwm1977]

下载oledb for foxpro

[zbboy80]

OLEDB for foxpro在哪里下载？

[lwm1977]

要不看看
http://www.zjonline.com.cn/vbbible/software/program/vb/tips2/database.htm#3

[hzybc]

Dim db As Database
Dim rs As Recordset

Set db = OpenDatabase("f:\fp", False, False, "foxpro 3.0") 'f:\fp指文件夹的名称
Set rs = db.OpenRecordset("a_z2001.dbf")