That was the one I didn't try, I was almost out of choices!
PS, what if I wanted output to look like:
811AD,SUDBURY++++++++,B021193
note the '+' being spaces.



>Try:
>COPY .. to .. delim with ""
>
>>I have the below data in a table acct(5), location(15),label(5)and I want to create the txt file shown below. Do I use copy to output type sdf, delimited, delimited with ",", not having too much luck creating what I want.
>>
>>
>>"output.txt" =
>>811AD,SUDBURY ,B021193
>>811AD,SUDBURY ,B020910
>>811AD,SUDBURY ,B022401
>>811AD,SUDBURY ,B023021
>>811AD,SUDBURY ,B023207
>>811AD,SUDBURY ,B024342
>>811AD,SUDBURY ,B024341
>>811AD,SUDBURY ,B024382
>>811AD,SUDBURY ,B024351
>>811AD,SUDBURY ,B024352
>>811AD,SUDBURY ,B020809
>>811AD,SUDBURY ,B021653
>>811AD,SUDBURY ,B023958