Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Question Unanswered: Convert Foxpro to Mysql

    Can anyone please tell me how I can convert FoxPro Database to MySql
    Thanks

  2. #2
    Join Date
    Mar 2004
    Posts
    8
    u want to use foxpro technology or MYSQL.B-coz from both the ways i.e. fm foxpro to mysql and vice-versa is possible.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Are you asking if a FoxPro executable can access a MySQL database? If so, it can if the machine that the exectuable is running on has an ODBC driver for MySQL and if you can change either the DSN or the connect string for the FoxPro program.

    If you are asking if the data in FoxPro DBF files can be imported directly into MySQL, the easiest way is to use a FoxPro program to do it.

    -PatP

  4. #4
    Join Date
    Jan 2002
    Location
    Czech Republic
    Posts
    14
    Try converters at dbconvert.com

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if there is not a native converter (you could try dbtools.com), then the only other route I can think of may be to migrate the data to Access, or write a custom update /data take on routine.
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Jul 2007
    Location
    Belgium
    Posts
    15
    From VFP, you can connect to MySQL and do just about anything you need to. For any differences in the SQL syntax, you can start here: SQL implementations, database servers, and VFP Tod means Fox

    I can post you some code examples if you need a head start.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •