>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.