Solved

Converting a Very Old FoxPro Database Over to Excel

Posted on 2014-04-02
3
2,326 Views
Last Modified: 2014-04-02
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
Comment
Question by:anuneznyc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 35

Assisted Solution

by:Dan Craciun
Dan Craciun earned 200 total points
ID: 39973458
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
 
LVL 42

Accepted Solution

by:
pcelba earned 300 total points
ID: 39973494
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
 

Author Comment

by:anuneznyc
ID: 39974095
Thanks for the suggestions, guys.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question