Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Unanswered: export .dbf file to MySQL

    I'm new to MySQL and know nothing about FoxPro. I am trying to find out if there is a way to take a .dbf file (FoxPro database) and import it into MySQL. There are actually several .dbf files and I want to take each one and import into one MySQL database. I don't have the FoxPro application, but only the .dbf files. Is there a way to do this? If so, any direction on how to accomplish would be greatly appreciated. Thanks for any help.

  2. #2
    Join Date
    Jul 2004
    Dundee, Scotland
    DBF files are not plain text. You can do one of two things. 1) Open up those files in Excel (it will open DBF files) and export them as CSV, or 2) find a class and programmatically import them (search for 'dbf').

    Last edited by yellowmarker; 07-22-04 at 12:59.

  3. #3
    Join Date
    May 2004
    i do it like this.
    use access to open the dbf file
    create a odbc to mysql database
    in access,you can export the data to mysql select export->odbc()

Posting Permissions

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