I am trying to upgrade my Foxpro2.6 Memo files (.fpt) to a database program called embark. The FPT files are unreadable.I need to get them into a ascii file or some way of deciphering, converting or even seeing the file as well as link to the data. HELP.....
rgbean (Programmer) Feb 27, 2003
First, you really should have started a new thread and not simply added on to this virtually unrelated topic.
That said, you normally don't access a memo (.FPT) file as a standalone entity. You should have a database (.DBF table) file with the same name. The .DBF has all the links to the locations of the data in the .FPT file. There are a number of ways to view this data - any version of FoxPro or VFP, Access, Quickview, and a number of freware / shareware viewers. To export the data, what program and technique you use will depend on what format "embark" wants it in.
Rick
THIS IS EMBARK's RESPONSE
Essentially what EmbARK requires to be able to import the memo data is discreet categories or columns (credit line, inscription) and a link to the corresponding FPT record. If you can find a way to Export the data from the DBF table in total, You may easily select only the memo data since the other information has already been imported into EmbARK.
Generally the process is this:
Export data from an existing DB as Tab delimited text
Open in Excel to review the info and clean it up if necessary
Copy the Excel data and Paste into a unformatted TXT file such as Wordpad or Simpletext
Import this TXT file into EmbARK.
We have retained the Fox Pro DB Object Id Numbers in the Temp ID field in EmbARK, so you may use that number to link the Fox Pro records with the corresponding EmbARK records.
rgbean (Programmer) Feb 27, 2003
First, you really should have started a new thread and not simply added on to this virtually unrelated topic.
That said, you normally don't access a memo (.FPT) file as a standalone entity. You should have a database (.DBF table) file with the same name. The .DBF has all the links to the locations of the data in the .FPT file. There are a number of ways to view this data - any version of FoxPro or VFP, Access, Quickview, and a number of freware / shareware viewers. To export the data, what program and technique you use will depend on what format "embark" wants it in.
Rick
THIS IS EMBARK's RESPONSE
Essentially what EmbARK requires to be able to import the memo data is discreet categories or columns (credit line, inscription) and a link to the corresponding FPT record. If you can find a way to Export the data from the DBF table in total, You may easily select only the memo data since the other information has already been imported into EmbARK.
Generally the process is this:
Export data from an existing DB as Tab delimited text
Open in Excel to review the info and clean it up if necessary
Copy the Excel data and Paste into a unformatted TXT file such as Wordpad or Simpletext
Import this TXT file into EmbARK.
We have retained the Fox Pro DB Object Id Numbers in the Temp ID field in EmbARK, so you may use that number to link the Fox Pro records with the corresponding EmbARK records.