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 ';'
>>
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up