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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FoxPro

From novice to tech pro — start learning today.