Hi! The files .fpt and .dbf(made in 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 sennse.
So my question is how to extract the text from the files? Foxpro 9 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?
Thanks
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.
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:
http://fox.wikis.com/wc.dll?Wiki~TableCorruptionRepairTools~VFP
I personally use Recover.
I have heard from others though that the CM Table repair is good too.
http://www.cmstory.com/index.php?name=Sections&req=listarticles&secid=2
Rick Schummer VFP MVP