Mobile app version of vmapp.org
Login or Join
Debbie626

: Export Foxbase database tables to csv I have no experience with Foxbase whatsoever and I'm used to working with MySQL via phpmyadmin or interfaces like that. My company has a third party database

@Debbie626

Posted in: #Csv #Database #Migration

I have no experience with Foxbase whatsoever and I'm used to working with MySQL via phpmyadmin or interfaces like that.

My company has a third party database we're trying to move away from, but we have no support from the company. The database is on our servers, but in a foxbase format. What kind tools do I need to convert these into other formats, or is there any type of admin UI I can tell them to use to export to csv or anything like that?

Basically I'm asking how to export the foxbase tables to csv. Sorry if this question isn't clear or you need more information. I will edit with anything else you need.

10.01% popularity Vote Up Vote Down


Login to follow query

More posts by @Debbie626

1 Comments

Sorted by latest first Latest Oldest Best

 

@Sue5673885

There are a few ways that you can do this, the easiest all involve using ODBC drivers for FoxPro and/or Dbase (depending on the version of the dbf and the specific driver).

Depending on the number of rows in the tables you could just open up the data in Excel through an ODBC connection and then export the data to CSV. You can also write up export code in any language where you can open the data through an ODBC connection.

Another option is to open the dbf in a slightly newer version of FoxPro (6.0 or higher should do) where you can use ANSI SQL commands to select the data into temp tables or cursors and then export it. You can do this because FoxPro is not just a database engine but also provides a REPL (like the Ruby irb) so you can perform selects and then export to CSV from within the FoxPro shell.

There is also this answer from StackOverflow that details a Python module that may also do what you need.

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme