English 中文(简体)
如何打开 .d01 的 FoxPro 文件
原标题:how to open .d01 foxpro file

I am building a basic POS app for my cousin s pharmacy store so that he can dump the software he is currently using and save on license cost.All the medicines name which he has painfully entered into the software have been stored in a file with .d01 extension. What i want is a way to read the contents of the .d01 file programmatically so that i can import the name of the medicines into my app. The s/w from which my cousin uses is built in Foxpro(coz i see a lot of .cdx,.idx,.dbf files) and the file which i want to import is with .d01 extension. when i open the file in notepad it is something like this http://img192.imageshack.us/img192/5528/foxpro.jpg

所以我猜它是一种数据库表或类似的东西。所以能否有人教我如何阅读这个文件,因为我对foxpro一点也不了解。

提前感谢所有抽出时间回复的人。


嘿,大家非常感谢您们的迅速回复。我尝试了Otávio提出的解决方案,它起作用了,现在我将编写一个小实用程序来读取dbf文件。

最佳回答

它有很大的可能只是一个普通的.dbf文件。将其复制到安全的地方,将扩展名更改为dbf,然后尝试从foxpro中打开它。

问题回答

尽管可能有.cdx文件,但文件的实际粘贴不像是 VFP 表的可视化可识别的头部格式... 即使是数据库容器的一部分。每个列名周围的字符看起来不对。它可能来自另一种也使用“复合索引”的语言。我甚至看到了一篇关于 Sybase 的 IAnywhere 的文章。如果最坏的情况是确定每行的长度是固定的,没有动态的列大小,你可以拿起这个文件,剥离看起来像头部的部分,只留下数据,并基于确定的长度常量字符的数量对其进行流读取。是的,这是一种暴力的方法,但只是一种选择。再次强调,这看起来并不像是 VFP 表。

顺便问一下,他使用的软件叫什么...我会调查一下看看是否有其他方面的迹象表明它的来源。

它看起来有点像DBF文件 - 可能是Clipper或其他什么。





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签