I want to enter the data in FoxPro but save the data in .xls format.
我想在FoxPro中输入数据,但以.xls格式保存数据。
4 个解决方案
#1
6
You can use EXPORT TO *FILENAME* TYPE XLS
您可以使用EXPORT TO * FILENAME * TYPE XLS
#2
3
COPY TO is more flexible: FIELDS LIKE or FIELDS EXCEPT.
COPY TO更灵活:FIELDS LIKE或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.
但是对于较新的Excel 5格式,请使用XL5。 XLS创建XLS,用户将被要求在使用新Excel保存时更改格式。
#3
1
Additionally, you can use COPY TO and specify the specific fields and field sequence, something like
此外,您可以使用COPY TO并指定特定字段和字段序列,例如
COPY TO SomeFileName fields MyFld1, MyFld2, MyFld3 type XLS
#4
-1
for exmple ossep12.dbf file
例如ossep12.dbf文件
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
6
You can use EXPORT TO *FILENAME* TYPE XLS
您可以使用EXPORT TO * FILENAME * TYPE XLS
#2
3
COPY TO is more flexible: FIELDS LIKE or FIELDS EXCEPT.
COPY TO更灵活:FIELDS LIKE或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.
但是对于较新的Excel 5格式,请使用XL5。 XLS创建XLS,用户将被要求在使用新Excel保存时更改格式。
#3
1
Additionally, you can use COPY TO and specify the specific fields and field sequence, something like
此外,您可以使用COPY TO并指定特定字段和字段序列,例如
COPY TO SomeFileName fields MyFld1, MyFld2, MyFld3 type XLS
#4
-1
for exmple ossep12.dbf file
例如ossep12.dbf文件
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