Foxpro to excel

I have 50 visual foxpro files in my computer. I want to transform that contents to excel is that possible??
If it's possible means how to that?
SATHISH KUMAR RAVIDesignerAsked:
Who is Participating?
 
Olaf DoschkeSoftware DeveloperCommented:
Do you have FoxPro itself, too, or just DBFs?

To convert is as simple as
USE some.dbf
EXPORT TO some.xls TYPE XL5

Open in new window


You don't get XLSX, but Excel can convert that into newer formats.

If you have more than 65536 rows you better go through CSV, but that's similarly simple:
USE some.dbf
COPY TO some.csv TYPE CSV

Open in new window


Bye, Olaf.
2
 
Martin MillerCTOCommented:
If you can output 2-D data (x-y), then... you can create:

Data output to CSV, then import in to excel
0
 
pcelbaCommented:
If you don't have Visual FoxPro then you may use free VFP Run-time and VRunFox9 application for this simple task. Just let us know if you decide to go this way.

Also the possibility to fill XLSX directly from VFP via OLE automation exists.
0
 
Martin MillerCTOCommented:
Olaf and Pcellba presented Good options, looking to close this.

Thank you!

Martin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.