如何从 fpt 和 dbf (FoxPro) 文件获取数据？
文件 .fpt 和 .dbf（在 Visual FoxPro 8 中创建）包含我需要获取或至少查看的文本（人类可读）。但我不能那样做。 MS Excel 不仅可以看到文本，还可以看到很多毫无意义的符号。
所以我的问题是如何从文件中提取文本？ Visual FoxPro 8 无法打开它，提示 soandso.fpt 丢失或无效，即使我已尝试打开该文件 (soandso.fpt)。
是否可以从文件 .fpt 和 dbf 中获取文本？
The files .fpt and .dbf (made in Visual FoxPro 8) have the text (readable for humans) which I need to get or at least to see. But I can't do that. MS excel sees not only the text but also a lot of symbols which make no sense.
So my question is how can I extract the text from the files? Visual FoxPro 8 can't open it saying that soandso.fpt is missing or invalid even though I have tried to open the very file (soandso.fpt).
Is it possible to get the text from the files .fpt and dbf?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
dbf2csv（我多年前编写的）可以将大多数 dBase 系列数据库（包括 FoxPro）转换为 .csv 或 .json 格式。它确实处理 FoxPro 备忘录文件。
它是免费的。它是用 Perl 编写的，因此当然包含源代码。您可以在这里下载：
http://burtonsys.com/download/dbf2csv.zip
它是目前版本为 10，日期为 2012 年 11 月 15 日。
这是一篇关于它的文章：
http://1stopit .blogspot.com/2009/06/dbf-to-mysql-conversion-on-windows.html
dbf2csv (which I wrote many years ago) can convert most dBase-family databases, including FoxPro, to .csv or .json format. It does handle FoxPro memo files.
It is free. It is written in Perl, so the source code is included, of course. You can download it here:
http://burtonsys.com/download/dbf2csv.zip
It is currently at version 10, dated 11/15/2012.
Here's an article about it:
http://1stopit.blogspot.com/2009/06/dbf-to-mysql-conversion-on-windows.html
您可以使用一些工具将 dbf 文件转换为 SQL，例如 PgDBF 或 dbf2mysql。我确信还有一些商业工具可以帮助您完成此任务。
You can use some tools for converting dbf files to SQL, such as PgDBF or dbf2mysql. I'm sure there are also some commercial tools which will help you with this.
通常，您应该能够使用 Excel 和内置查询从表 (DBF) 或备注字段（存储在 FPT 中）获取数据。基于“符号”的注释以及 Visual FoxPro 9 无法打开的事实桌子，听起来你遇到了腐败。有一些工具可用于修复损坏。
这是一个列出了许多好工具的网站：
我个人使用Recover。
我从其他人那里听说 CM 表修复也不错。
里克·舒默
VFP MVP
Normally you should be able to get the data from the table (DBF) or the memo fields (stored in the FPT) using Excel and the query built in. Based on the comment of the "symbols" and the fact Visual FoxPro 9 cannot open the table, it sounds like you have run into corruption. There are tools available to fix the corruption.
Here is a site that lists a number of good tools:
I personally use Recover.
I have heard from others though that the CM Table repair is good too.
Rick Schummer
VFP MVP