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


© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic