INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Jobs from Indeed

export foxpro table to excel

export foxpro table to excel

(OP)
Hi there, I don't know how to write codes, but is there a way to export a foxpro table to excel worksheet? Thanks.

RE: export foxpro table to excel


Use a product called XFRX it can be found here.
http://www.eqeus.com/

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

RE: export foxpro table to excel

You can do this interactively using the Export Wizard (File | Export on the menu) or from the Command Window or a program with:

USE MyTable
COPY TO MyWorkbook TYPE XL5

Tamar

RE: export foxpro table to excel

You can use either COPY TO or EXPORT with the TYPE parameter.  I use TYPE XL5.

Tony

RE: export foxpro table to excel

You might want to use FRX2Any's Document Generater - www.frx2any.com
There is a sample of using in \Samples\Document generation\ folder.
You can programmatically create HTML, RTF, EXCEL, PDF, and IMAGE file/document.

HTH

RE: export foxpro table to excel

(OP)
Thanks everyone for the solutions!

RE: export foxpro table to excel

use mydbf in 0
export to c:\mydbf.xls type xls

RE: export foxpro table to excel

(OP)
hello, it's TYPE XL5 OR XLS? Thanks!

RE: export foxpro table to excel

TYPE XLS creates Excel 2.0. TYPE XL5 creates Excel 5.0.

RE: export foxpro table to excel

(OP)
thanks for your response. but how do I know if I need Excel 2.0 or Excel 5.0, I only I am using MS Office 2000.

RE: export foxpro table to excel

Quote:

how do I know if I need Excel 2.0 or Excel 5.0, I only I am using MS Office 2000.

Use Excel 5. It can handle more rows than Excel 2.

Geoff Franklin
http://www.alvechurchdata.co.uk

RE: export foxpro table to excel

(OP)
If I got more rows than it can handle, can I use condition when I use command "copy to", for example, "while date >=01-Jan-2000"? Thanks!

RE: export foxpro table to excel

Yes, and you can also use a FOR condition.

Regards,
Jim

RE: export foxpro table to excel

(OP)
Could you please kindly give an example and show me how to write the command, sorry I am not familiar with Foxpro commands. Thanks Jim.

RE: export foxpro table to excel


COPY TO ... TYPE XL5 FOR date>={01/01/2000}
or
COPY TO ... TYPE XL5 FOR date>=DATE(2000,01,01)
or
COPY TO ... FOR date>=DATE(2000,01,01) TYPE XL5

In your case, with FOR clause you will be better off than with WHILE.

RE: export foxpro table to excel

(OP)
Thank you very much for your help!

RE: export foxpro table to excel

Hummmm... I just tried in FoxPro 6.0 to write out a table using the XL5 and got an extension wk1 spreadsheet. Does this only work with later versions of FoxPro?

RE: export foxpro table to excel

[quote]Does this only work with later versions of FoxPro?[\quote]

COPY TO TEST TYPE XL5 produces test.xls file in my VFP6. Could you post the line of code which produced a WK1 extension?

Geoff Franklin
http://www.alvechurchdata.co.uk

RE: export foxpro table to excel

Forget previous post. It would help if I had been looking in the folder I had written to. Now I don't know where I got the wk1 from... Oh well.

RE: export foxpro table to excel

wk1-file is from Lotus123 spreadsheet though?
-Bart

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close