Exporting Data

You can export data from your Visual FoxPro tables to text files, spreadsheets, or tables used in other applications. The exporting process requires a source table and the destination's file type and name. If you want, you can select which fields and record to export. You can use the new file in any application that supports the file type you select.

Choosing a File Type to Export

The following table lists the file types you can export from Visual FoxPro.

File type File extension Description

Tabs delimited

txt

A text file with a tab separating each field.

Comma delimited

txt

A text file with a comma separating each field.

Spaces 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.

Table

dbf

A Visual FoxPro, FoxPro, FoxBASE+®, dBASE, or Paradox 3.5 or 4.0 table.

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. You can export a maximum of 65,535 rows, which includes one row reserved for the field header.

Lotus 1-2-3

wks wk1

A Lotus 1-2-3 spreadsheet for releases 1-A, 2.x, and 3.x. The column cells become fields and rows become records.

For more information on exporting, see the COPY TO command.

See Also


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