How to: Export Text Files
If you export to a text file, Visual FoxPro assumes that your fields are separated by commas and that each character field is enclosed by quotation marks. If you have set the decimal point character to display as a comma, numeric and currency data might be parsed into separate fields.
To export to a text file
Use the COPY TO Command with the appropriate DELIMITED clause as shown in the following table.
For these separators
Use this DELIMITED clause
Commas between fields and quotation marks enclosing character fields
DELIMITED
Character fields enclosed by a character other than quotation marks
DELIMITED WITH delimiter
Tabs between fields
DELIMITED WITH TAB
Spaces between the fields
DELIMITED WITH BLANK*
* Date and times separated by a space will be parsed as two fields with these keywords
See Also
Tasks
How to: Export Data to New Files
How to: Export a Quantity or Range of Records
How to: Export Records That Match Conditions
How to: Control the Record Export Process
How to: Export Numeric or Currency Values