Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export to Excel
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Miscellaneous
Thread ID:
01060842
Message ID:
01060846
Views:
9
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform