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.

Answer 1

You can use EXPORT TO *FILENAME* TYPE XLS

Answer 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

Answer 3

COPY TO is more flexible: FIELDS LIKE or FIELDS EXCEPT.

But do use XL5, for newer Excel 5 format. XLS creates XLS and users will be asked to change formats when they save with new Excel.