How to get the data from fpt and dbf (FoxPro) files?

visual-foxpro foxpro
user237591 picture user237591 · Dec 23, 2009 · Viewed 28.2k times · Source

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?

Answer

Michal Čihař picture Michal Čihař · Dec 23, 2009

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.

Related questions

How to convert Visual Foxpro database into SQL Server database

One of my clients has a Foxpro database (.DBF file). I need to convert it into a SQL Server 2008 database. Does anyone have any idea how to do this? Kindly give me solution. Thanks in advance....

Read More
How can I export data from a foxpro database to excel(.xls)?

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

Read More
Convert Numeric to Character

I'm not very familiar with FoxPro and I'm running into problems trying to modify a report. I have a numeric value that I want to convert to text so that I can get the first four characters, but I am …

Read More