Page 1 of 1

Export as tab delimited text with a header

Posted: Tue Sep 14, 2010 11:49 am
by Eric
Use this command to export your data as a tab separated text file with a header record:

Code: Select all

COPY TO "c:\output.txt" TYPE CSV
SELECT * FROM (ALIAS()) WHERE .F. INTO CURSOR _convtotab READWRITE
APPEND FROM "c:\output.txt" TYPE DELIMITED
COPY TO "c:\output.txt" TYPE DELIMITED WITH TAB