>>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.