Export file as Tab Delimited WITH or WITHOUT Quotes

[Kristen]

To export as tab delimited text with quotes, use:

Code: Select all

COPY TO "C:\TEST_WITH_QUOTES.TXT" TYPE DELIMITED WITH TAB

To export as a tab delimited WITHOUT quotes, use:

Code: Select all

COPY TO "C:\TEST_WITHOUT_QUOTES.TXT" TYPE DELIMITED WITH "" WITH TAB