Wednesday, February 22, 2012

View and convert Visual Foxpro .fpt files

Foxpro (.dbf) databases store memo fields in an separate file with the .fpt extension. I've been using DBF Explorer to poke around in a .dbf database recently but all of the memo fields were left blank. Luckily I've come across a nifty little perl script which will convert .dbf AND .fpt (in situ no less) files into .csv or apparently .json. You can find dbf2csv free at Burton Systems Software. The license even states that the script is "uncopyrighted". Easy as pi!

No comments:

Post a Comment