export foxpro table to excel

[ulnaoar]

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

 

[Mike Gagnon]

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.

 

[TamarGranor]

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

 

[tvign]

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

Tony

 

[mtchary]

You might want to use FRX2Any's Document Generater -

http://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

 

[ulnaoar]

Thanks everyone for the solutions!

 

[fretboard]

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

 

[ulnaoar]

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

 

[teresas]

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

 

[ulnaoar]

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.

 

[alvechurchdata]

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

 

[ulnaoar]

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!

 

[JimWWinter]

Yes, and you can also use a FOR condition.

Regards,
Jim

 

[ulnaoar]

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.

 

[Stella740pl]

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.

 

[ulnaoar]

Thank you very much for your help!

 

[furmious]

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?

 

[alvechurchdata]

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

 

[furmious]

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.

 

[alvechurchdata]

It would help if I had been looking in the folder I had written to.

Your first "senior moment"?

Geoff Franklin

http://www.alvechurchdata.co.uk