All geek questions in one place

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

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

+4
source share
4 answers

You can use EXPORT TO *FILENAME* TYPE XLS

+6
source

COPY TO is more flexible: USEFUL LINES OR FIELDS EXCEPT.

But use XL5 for the new Excel 5 format. XLS creates XLS, and users will be prompted to change the formats when they are saved using the new Excel.

+3
source

Alternatively, you can use COPY TO and specify specific fields and a sequence of fields, something like

 COPY TO SomeFileName fields MyFld1, MyFld2, MyFld3 type XLS
0
source

for exmple ossep12.dbf file

 COPY TO "c:\kbk.xls" NEXT 50000 FIELDS Ossep12.uniqueid,Ossep12.crmacct,Ossep12.billno,Ossep12.ll,Ossep12.bb,Ossep12.sc,Ossep12.st,Ossep12.os,Ossep12.bldt,Ossep12.classcode,Ossep12.acsubtype,Ossep12.name,Ossep12.add1,Ossep12.add2,Ossep12.add3,Ossep12.city,Ossep12.pin,Ossep12.inactdt,Ossep12.status,Ossep12.phone,Ossep12.exgcode,Ossep12.bldate,Ossep12.inactivedt TYPE XL5
-1
source

Source: https://habr.com/ru/post/1301578/

More articles:


All Articles