问题描述
我为NS省政府工作，目前使用Visual FoxPro 9.
I work for the NS Provincial Government and currently use Visual FoxPro 9.
展望未来，我们的服务台将不再支持此计划。我们也正在转向使用通信跟踪系统（CTS）的新软件。
Going forward, our Help Desk will no longer be supporting this program. We are also shifting to new software for our Correspondence Tracking System (CTS).
我的问题是： 如何将数据从FoxPro传输到Excel或Word等可用（可搜索）程序。
My question is: How do I transfer data from FoxPro to a useable (searchable) program like Excel or Word.
当我打开程序时，没有涉及导出的功能。 我能做的唯一一件事是报告未完成的通信。 我想我需要知道如何"通过后门进入"。
When I open the program, there are no features referring to exporting. The only thing that I can produce is a report of outstanding correspondence. I think that I need to know how to 'get in through a back door'.
任何人都可以帮助我吗？
Can anyone help me?
问候，
Joanne Bolger
Joanne Bolger
推荐答案
Foxpro中有一个命令可以将数据从VFP表复制到Excel文件，但它有一些MEMO字段的限制不会被转移到excel文件，并且记录的限制会被导出到excel文件中（可以导出最多65,535行）
There is a command in Foxpro to copy data from VFP table to Excel file but it is having some limitations of MEMO field will not get transferred to excel file and limitation of records get exported to excel file (can export a maximum of 65,535 rows)
从VFP 9帮助提取
复制到 FileName [DATABASE DatabaseName [NAME
LongTableName ]] [FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPT
Skeleton ] [范围] [FOR lExpression1 ] [WHILE
lExpression2 ] [[WITH] CDX] | [[WITH] PRODUCTION] [NOOPTIMIZE] [[TYPE] [FOXPLUS | FOX2X | DIF | MOD | SDF | SYLK | WK1 | WKS | WR1 | WRK | CSV | XLS | XL5 | DELIMITED [WITH
分隔符 |与BLANK |与TAB | WITH CHARACTER 分隔符
]]] [AS nCodePage ]
COPY TO FileName [DATABASE DatabaseName [NAME LongTableName]] [FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPTSkeleton] [Scope] [FOR lExpression1] [WHILElExpression2] [ [WITH] CDX ] | [ [WITH] PRODUCTION ] [NOOPTIMIZE] [ [TYPE] [ FOXPLUS | FOX2X | DIF | MOD | SDF | SYLK | WK1 | WKS | WR1 | WRK | CSV | XLS | XL5 | DELIMITED [ WITHDelimiter | WITH BLANK | WITH TAB | WITH CHARACTER Delimiter ] ] ] [AS nCodePage]
最好去自定义包导出它到Excel。
It is better to go for customized package to export it to Excel.
- 你也可以将VFP数据迁移到不同的数据库，如MS -SQL，MYSQL，Postgres，以便您可以查询数据。
- You can also migrate VFP data to different database like MS-SQL, MYSQL, Postgres so that you can query data.
这篇关于将数据从FoxPro导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！