>>>>>Is it possible to create a csv file with comma delimiters but no quotation marks around the text?
>>>>>
>>>>>example 710240, COLIN NORTHWAY, TEST, TEST, LONDON, WC1 2EE 1,27.00,aaa,bbb, 1, DOCUMENTS
>>>>
>>>>Yes it's possible but w/o header. You have to use DELEIMITED WITH ... WITH CHARACTER
>>>
>>>Sergey
>>>
>>>I know you've answered this for me b4 but I have forgotten how to code it
>>>
>>>what would be the exact syntax for this file which is to be pipe delimited?
>>>
>>>Copy To c:\global\citylink.csv Type Delimited With Character |
>>

Copy To c:\global\citylink.csv Delimited With Character "|"

>
>Tore
>
>That doesn't work but Sergey's answer does
>
>Thanks
>
>Colin

I didn't read the whole thread, so I overlooked that you didn't want the " " text delimiters. Anyway, I'm glad that you got to work.