Extracting data from Visual FoxPro databases

I just got some 20Gb of data in a Visual FoxPro database with a custom frontend probably written in the same framework, and need to extract that data in any well-known format. I don't know anything about VFP in particular, but as it is SQL, there should be a way of opening an SQL console, or maybe an vfpdump utility. How can I do that?

Everything I have now are a bunch of obscure binary files and a frontend executable.

database

whitequark

Posted 2010-11-16T05:51:21.323

Reputation: 14 146

Answers

dbview file.dbf > outfile.csv

dbf2mysql file.dbf > file.sql

jet

Posted 2010-11-16T05:51:21.323

Reputation: 2 675

Are you on Windows? You could check out the ODBC driver.

Joril

Posted 2010-11-16T05:51:21.323

Reputation: 1 879

Yes, that frontend runs on Windows, but how can I 'connect' to the database consising of a several local files? – whitequark – 2010-11-16T14:31:23.307

What are their file extensions? Anyway the ODBC driver should take care of them – Joril – 2010-11-16T14:51:10.247