[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3170
  • Last Modified:

Converting a Very Old FoxPro Database Over to Excel

I have a client with a customized database that was created in FoxPro circa 1998. It was running off a Windows 2003 Server that recently crashed. In any case we were thinking of decommissioning that server since the company has recently downsized to just 2 employees.

The database is essentially used as an electronic Rolodex. Nothing overly complex about it. I would like to make that data viewable, ideally, in an Excel spreadsheet.

How can I convert that FoxPro database file into an Excel spreadsheet? Keep in mind that since the server crashed, I can no longer run the FoxPro application and try to export it into a CSV formated file from there. We also no longer have the installation media for that super-old version of FoxPro.
0
anuneznyc
Asked:
anuneznyc
2 Solutions
 
Dan CraciunIT ConsultantCommented:
You can use a dbf viewer to view and export your data. A quick google search shows many paid options, the only free one from a reputable source is this:
http://www.softpedia.com/get/Office-tools/Other-Office-Tools/DBF-Viewer-Plus.shtml

Or use Access.

HTH,
Dan
0
 
pcelbaCommented:
Even the latest Visual FoxPro can read old FoxPro data without any problem.

And if you know FoxPro language then you may use the free Command prompt version (VRunFox9).
Source code is available here: https://github.com/EdLeafe/vRunFox
Compiled version is here: http://leafe.com/dls/vfp  (search for VRunFox)

You'll also need Visual FoxPro 9 run-time libraries from here: http://archive.msdn.microsoft.com/FoxPro/Release/ProjectReleases.aspx?ReleaseId=125

You'll need just two commands to convert DBF file into CSV:

USE d:\path\filename
COPY TO d:\otherPath\NewFilename.CSV  TYPE CSV

If you would need to learn more FoxPro commands just download the free VFP 9 SP2 help from here: http://vfpx.codeplex.com/  (not all commands are supported under the VFP run-time)

Or simply ask here...
0
 
anuneznycAuthor Commented:
Thanks for the suggestions, guys.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now