The Process of Appending Data
You can add your text, spreadsheet, or table data to an existing Visual FoxPro table. By default, Visual FoxPro uses the file type to map the source fields to the destination table. You can also select fields and records to append. If you want to control the field mapping, you can use theImport Wizard, but field selection and logical expression options are not available.
Choosing a File Type to Append
The following table lists the file types you can append to Visual FoxPro:
| File Type | File Extension | Description |
|---|---|---|
| Table | dbf | A FoxPro® table from a database outside the current database or a dBASE file. |
| Tab delimited | txt | A text file with a tab separating each field. |
| Comma delimited | txt | A text file with a comma separating each field. |
| Space delimited | txt | A text file with one space separating each field. |
| System Data Format | sdf | A text file with fixed length records ending with a carriage return and line feed. |
| Microsoft Excel | xls | A Microsoft Excel (versions 2.0, 3.0, 4.0, 5.0, and 97) worksheet format. The column cells become fields and rows become records. |
| Lotus 1-2-3 | wks wk1 wk3 |
A Lotus 1-2-3 spreadsheet for releases 1-A, 2.x, and 3.x. The column cells become fields and rows become records. |
| Borland Paradox | db | A Paradox table for versions 3.5 and 4.0. |
For more information on appending files, see the APPEND FROM command.
See Also
Importing from Microsoft Excel | Appending Data with the Import Wizard | Importing and Exporting Data | Appending Data to an Existing Table | Selecting Fields to Append | The Process of Importing Data