thanks, this works.



>COPY TO MyCSV.CSV TYPE SDF - should work if it's just one column of numbers.
>
>Bear in mind that the definition of a CSV file is that the first row *is* column headers, and some applications that import CSVs expect that to be the case. Are you completely sure the client wants files with a .CSV extension but no column headers?
>
>>the header is gone, but this time I have:
>>
>>

>>'10001'
>>'10002'
>>

>>
>>instead of
>>
>>

>>10001
>>10002
>>

>>
>>
>>
>>
>>
>>
>>
>>>>It has to be Excel csv file, this is the request from the client :(
>>>
>>>All CSVs are Excel files :-)
>>>Try this:
>>>

>>>USE YourTable
>>>COPY TO mytxt.csv DELIMITED WITH '' WITH CHARACTER ';'
>>>