After DBF is converted to excel, the data is changed to TXT and then FoxPro is imported to DBF format, but it is a problem!

DBF -------------- Excel

 

1. Files in VFP --- Export

Type: excel5.0

To: where you store Excel files

 

2. Modify the data you want to modify in excel5.0, and convert the data with a triangle in the upper left corner to Data.

 

 

3. Save as: Text Document (tab-separated) (*. txt) Form

 

4. import data from VFP to DBF format.

 

Note that multiple columns may occur during VFP import in actual operation. Currently, this issue is not fixed.

 

In addition, the TXT file can be directly imported into the database by sqlsever.