Dim conADO As ADODB.Connection Dim rsVFP As ADODB.Recordset strCon = "Driver={Microsoft Visual FoxPro Driver};" & _ "SourceType=DBF;" & _ "SourceDB=D:\Temp\;" & _ "Exclusive=No;" Set conADO = New ADODB.Connection conADO.Open strCon Set rsVFP = New ADODB.Recordset rsVFP.Open "Select * From myDBF", conADO .. etc.Again, this is for a VFP free table directory (d:\Temp\). The connection string for a VFP DBC is slightly different.