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?
 Uppsala
 Sweden
 Anders Altberg
 To: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 Tags
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.

-Anders

ENTIRE THREAD

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