>I have a table with numeric, integer, character, and date fields and it's mandatory to create an export file of type tab delimited.
>
>Using the COPY TO filename DELIMITED WITH TAB is fine and dandy, except for the fact that all character type fields get exported with doble quotes(") at the beginning and end of each value. The accounting package that needs to import these values will not understand them correctly since it takes no "
>
>Now, I tried every possible combination of syntax values and everything else until the only way I could get it to work was with some spaghetti code that my buddy and I wrote for it.
>
>I tell you...
>
>
>
>
>Any ideas? TIA

Gil --

Enclosing character strings in quotes is standard for ASCII delimited data. Most applications that have an import mechanism should be able to recognize this convention without any problem. Is it possible that your accounting package has some configuration settings that need to be adjusted?

Another possibility would be to see if your accounting package will accept another format. Excel, DBF, and even SDF formats are commonly recognized by such programs these days, and all are easy to generate with COPY TO.

Hope this helps -- Bill