Microsoft KB Archive/95676

{| = APPEND FROM Command Appends Blank Records =
 * width="100%"|

ID: Q95676

The information in this article applies to:


 * Microsoft FoxPro for Windows, versions 2.5 and 2.5a
 * Microsoft FoxPro for MS-DOS, versions 1.02, 2.0, 2.5, and 2.5a
 * Microsoft FoxBASE+ for MS-DOS, version 2.1

SUMMARY
To append from one database to another, the fields in the source database must have the same names as the fields in the target database. Otherwise, blank records will be appended to the target file.

For example, if TEST_A.DBF has a field called NAME and TEST_B.DBF has a field called NICKNAME, the following code will append blank records to TEST_A:

USE TEST_A APPEND FROM TEST_B The number of blanks appended will be equal to the number of records in TEST_B.DBF. To work around this problem, do one of the following:

 Modify the structure of TEST_B to change &quot;NICKNAME&quot; to &quot;NAME&quot;. -or- Use the COPY TO ... TYPE DELIMITED command to first copy the records in TEST_B.DBF to a delimited ASCII text file, and then use the APPEND FROM ... TYPE DELIMITED command to append the records from the text file to TEST_A.DBF.

Additional reference words: FoxDos FoxWin 1.02 2.00 2.10 2.50 2.50a KBCategory: kbprg KBSubcategory: FxprgGeneral
 * }