FoxPro 2.6 linking???

[TheRealDeal]

Is there a way of linking to a FoxPro *.DBF file and utilize the current *.CDX file? I do not have it listed in the available(Built-in) list of external linking dBase options. Just in case, I use Access 2000.

 

[Databaseguy]

I've had problems with earlier versions of FoxPro and ODBC.

However, the following is a way to get at the data"

Dim rstFox As New ADODB.Recordset
Dim strSQLFox As String
Dim connFoxPro As String
connFoxPro = "Driver={Microsoft Visual FoxPro Driver};" & _
                     "SourceType=DBF;" & _
                     "SourceDB=\\yourpath;" & _
                     "Exclusive=No"
strSQLFox = "SELECT * FROM yourtable.dbf"
rstFox.Open strSQLFox, connFoxPro, adOpenDynamic, adLockOptimistic
With rstFox
  .do something
End With

Tyrone Lumley
augerinn@gte.net