Solved

Converting a Very Old FoxPro Database Over to Excel

Posted on 2014-04-02
3
1,657 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel Formula 4 28
Search for a value in Column? 5 21
Excel copy picture into Outlook email 7 45
Error in formula not increasing value 2 13
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
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 view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

911 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

22 Experts available now in Live!

Get 1:1 Help Now