VB6 on FoxPro
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
Web Development
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
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.
by nicemaster
by nicemaster
This discussion is closed to new replies.
Sort by Trending