Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting Data to an ODBC DBF using SQL

Status
Not open for further replies.

Jimgarry

MIS
May 16, 2000
112
Im working with an accounting system using Pervasive.sql.&nbsp;&nbsp;I need to export data from a vfp6 dbf into a predefined Pervasive dbf.&nbsp;&nbsp;I have created a view and a connection into the Pervasive dbf but I cannot add records to it.&nbsp;&nbsp;any suggestions.&nbsp;&nbsp;Im not sure what commands in fox I would use.&nbsp;&nbsp;Thanks for your help <br>&nbsp;
 
Jim, you can check the FAQ in this forum for more specifics, but basically you have two choices: creating a remote view and inserting into it, or sending SQL pass-through insert statements. <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top