>>>Is there a way to Copy or Export a table to Excel without including the field names in the first row? I can go in an remove the row thru OLE, but was wondering if there's a simpler way.
>>>
>>>TIA for your help -
>>>Margaret
>>
>>Try this:
>>

>>CREATE CURSOR cTest (Fld1 C(10), Fld2 N(10))
>>FOR asd = 1 TO 10
>>    INSERT INTO cTest VALUES (TRANSFORM(asd),asd)
>>NEXT
>>COPY TO test.csv DELIMITED WITH CHARACTER ";"
>>

>>Excel will opened CSV file w/o field names
>
>That does export the data without the field names, but Excel does not recognize the separate fields in the string. If a do an addional sequence as follows:
>
>x = filetostr('text.csv')
>x = strtran(x,'";"','","')
>y = strtofile(x,'text.csv')
>
>then the file is legible to Excel again. Of course - one must be careful about the character chosen for the delimiter to ensure that data is not misinterpreted for the export and strtran.
>
>Thanks much for your help.


I tried with comma first and the Excel didn't recognise it :o)) So I changed to ";" and all worked. I don't know why Excel gets delimiters from Regional stting when the file is CommaSepparatedValues?