Share via


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 | Process of Importing Data