Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing old Dbase4 data
Message
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01059107
Message ID:
01059285
Views:
10
It looks like it will. If the viewer can be automated that would be great. But if it cannot be automated, then you would have to do it manually.

With a little dBaseIV exe you could RUN the EXE from you VFP program without having to go in and out of the viewer.
*VFP wouyld look like this
RUN myDB4TODB3 && Note cannot use the /N because VFP will continue to execute
               && even though file parse is not complete
*the dBaseIV code  would look like this:
<pre>
*myDB4TODB3.PRG - a dBaseIV EXE
USE mydBaseIV.DBF
copy to mydBaseIII.DBF TYPE DBMEMO3 && Now the memo fields are db3
USE
QUIT
* Execution is returned to VFP
USE myVFPDBF
APPEND FROM mydBAseIII.DBF
But ....
You should check the VFP help system for SYS(2029), APPEND FROM and the USE command (that has a DB4 to VFP converter).

>I wonder if that DBFviewer application would work for this?
>http://www.dbf2002.com/
>
>>You could copy the DB$ DBF to a TXT delimited file and then append them to your VFP DBFs.
>>
>>If this will be a recurring process you might need some kind of DbaseIV intermederary. DO you have a dBaseIV license?
>>
>>
>>>I need to extract data from a very old system that stores its data in Dbase 4. Although I can open the tables without any problems in VFP9/8/6, FPW2.6 and FPD2 (I still have all these versions) none of the programs is showing me the real contents.
>>>
Imagination is more important than knowledge
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform