VB6 and FoxPro

[oldwen]

Can anyone tell me how to create a MS FoxPro table using VB6. Basically I have an application that has a FoxPro backend and I need some data to be pulled from an oracle database, then create a table and insert that data into the newly created FoxPro table. Can this be done?

Oldwen

 

[dilettante]

You should be able to create the FoxPro database using ADOX then then use ADOX or SQL DDL/DML statements via ADO to create and populate the tables.

See:

OLE DB Provider for Visual FoxPro
Download: Microsoft OLE DB Provider for Visual FoxPro 8.0
ADO Programmer's Reference
Visual FoxPro 8.0 SQL Commands and Functions

... to get started.

This should give you the basic tools and references to accomplish this via VB6 (or even VBScript) on a machine that doesn't have Visual FoxPro installed but does have MDAC 2.6+ installed.