>Is there a way to export a table to a standard text file (filename.txt) with the following requirements:
>1. No quote marks around character fields
>2. Tab as the seperator between fields
>
>The application needs to read a text file with IP Address and Mac Address that looks like:
>-> = a tab CHR(9)
>11.111.1.111 -> a1b1c1d1e1f1
>222.222.222.222 -> a2b2c2d2e2f2
>3.3.3.3 -> a3b3c3d3e3f3
>
>I've tried every combination of the "copy to" command and even tried using the "set alternate to" method, but the best I get is the text with spaces where the [tab] character should be.
>
>Colombo.

Check FAQ #8016

COPY TO 'TabDelimitedFile.txt' DELIMITED WITH "" WITH CHARACTER TAB