Discussion Locked

VB6 on FoxPro

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anybody knows how to connect and manipulate a Foxpro table (.DBF) using DAO or ADO on VB6? I need to transfer records from Access to FoxPro.

Thanks

3 replies

by sl-campbell

This is DAO:
Dim dbsFox As Dao.Database
Dim rs As Dao.Recordset

Set dbsFox = DAO.OpenDatabase("\\FoxPro\Data\AP", False, False, "FoxPro xxx;") 'xxx is the version

Set rs=dbsFox.OpenRecordset("myTable")

The Database name is the full path (for MS FoxPro DBC the path must include the .dbc file)

Source table name is the .dbf file name with-out the extension, or use the complete file name with the extension but substitute a # sign for the dot that precedes the file extension - for DBC use the name in the DBC.

Still problems? Post a comment to your question and I will get back to you.

This discussion is closed to new replies.