your perfectly right, i never saw the ".CSV" part of your original post and
tried

copy to myFile type CSV delimited

~M

>You do NOT need to rename. Check my 1st post:
>

copy to myFile.CSV type delimited

>Cetin
>
>
>>our customer needs the file as a csv, the delimited is the same internally as the csv but they need the file to have a csv extension. i used the delimited command and the next line down use the rename command to change the extension and it now gives me the result i need.
>>~M
>>
>>>Forgive my ignorance but what is a csv file then?
>>>Do not use "type csv" but "type delimited".
>>>Cetin
>>>
>>>>that does remove the top line perfectly but the file is a txt file, type csv does not work with it.
>>>>~M
>>>>
>>>>>>hi all,
>>>>>>i have what i hope is an easy one. I have a customer and i export details to a csv file for them. on the first line it lists the field names but i want to remove this, i searched the help but no joy there, is there a way to say copy to newfile9 type csv "no header" or something?
>>>>>>~M
>>>>>
>>>>>

copy to myfile.csv type delimited

Cetin