Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Anders Altberg
 To: prasanna kunder
  Where is prasanna kunder?
 prasanna kunder
Subject: RE: mySql(6)
Thread ID: 373367 Message ID: 373387 # Views: 56 # Ratings: 2
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, March 21, 2013 9:15:51 PM         

> Hello Experts
> can i add vfp.dbf to mysql database
> i have vfp.dbf , same file name and field structure want keep
> how it's possible
> thank again

Of course. Use the CREATE TABLE in a command you send from VFP to MySQL and create a table like your DBF.
Then fill it with data from by way of a remote view, or a CursorAdapter, or row by row with SQLEXEC().
You can also make a comma-delimited textfile or an XML file in VFP and make MySQL import from any of those.



mySql(6) Posted by prasanna kunder @ 3/21/2013 5:36:22 PM
RE: mySql(6) Posted by Anders Altberg @ 3/21/2013 9:15:51 PM
RE: mySql(6) Posted by Tom Saddul @ 3/22/2013 3:32:31 AM
RE: mySql(6) Posted by anand kulkarni @ 3/23/2013 5:33:06 AM