How can I export data from a foxpro database to excel(.xls)?

Question

I want to enter the data in FoxPro but save the data in .xls format.

Solution 1

You can use EXPORT TO *FILENAME* TYPE XLS

Solution 2

Additionally, you can use COPY TO and specify the specific fields and field sequence, something like

COPY TO SomeFileName fields MyFld1, MyFld2, MyFld3 type XLS

Comments

[John Janssen]

Depending on some group polices your company may have in place, you may not be able to modify this type of file. I suggest using EXPORT TO "[INSERT FILE LOC AND NAME HERE"] XL5