Solved

Converting a Very Old FoxPro Database Over to Excel

Posted on 2014-04-02
3
1,521 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
3 Comments
 
LVL 34

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 41

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now