accessing Visual FoxPro tables in VB6?

[violetstarlight]

Does anyone know if you can access a FoxPro table data in Visual Basic 6? I am writing an app that has to access data from a FoxPro program that was written in FoxPro 6.0.

Any help would be great!

 

[Kendel]

Check out this thread:

thread709-337856

 

[violetstarlight]

This is definately very helpful, just one question. What would the Driver be in the connect statement? ODBC, etc?

References: MS RDO 2.0
Dim SQL As String
Dim cn As New rdoConnection
Dim rs As rdoResultset

cn.Connect = "SourceType=DBF;" _
& "SourceDB=C:\Rob;" _
& "Driver={Microsoft Visual FoxPro Driver}"

cn.CursorDriver = rdUseOdbc
cn.EstablishConnection "rdDriverNoPrompt"

SQL = "SELECT * FROM TableName" 'should be a free table

Set rs = cn.OpenResultset(SQL, rdOpenKeyset, rdConcurRowVer)

 

[Kendel]

That would be ODBC. Good luck!