I need to convert some FoxPro tables (.dbf files, with .fpt files for memos) into a MySQL database. I've looked online for hours and hours for ways to do this. I found a Perl module called XBase, but I don't have the server so I can't install any modules. I found a PHP script called dbfConverter, but that doesn't work with FoxPro memo files (.fpt), only with dBase memos (.dbt). So I either need a script that can read in FoxPro 2.x tables and add them to a MySQL database, or I need a script that can convert .fpt files to .dbt files. I found the structures of the file formats I want to convert (http://www.e-bachmann.dk/docs/xbase.htm), but that would be really hard for me to program, methinks. I hope someone can help. Thanks.

    I'm making this site for someone else. They have a big database (they use FoxPro 2.something for it) and they want to be able to update it themselves just by uploading their files and executing a script. They're paying for a third party host that has an Apache server and a MySQL database, so there's no way I can really install anything on the server. So I have to write a script that updates their database based on only .dbf's and .fpt's.

      going through a temporary CSV file, you'd just have to create an import script for them to trigger

        Hmm, well I don't even know what a CVS script is. Can you enlighten me? Do you need anything special installed on the server to use one? Would I have to write my own script, or would there be one out there already made?

          CSV is comma delimited values

          data1,data2,data3
          datu1,datu2,datu3
          dato1,dato2,dato3

          easy to import through upload and process script (which i got bundled for you guys after numerous requests)

            Write a Reply...