>>>>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 |
>
>
>... DELIMITED WITH "" WITH CHARACTER "|"
>
Sergey
A star as ever
Thanks
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing