Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does COPY TO TYPE XLS Still Output Field Names in VFP7?
Message
 
 
To
06/08/2001 16:44:34
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00540385
Message ID:
00540414
Views:
25
>>>Does anyone know if the COPY TO TYPE XLS still puts the field names as the first row of the spreadsheet in VFP7?
>
>>If you don't want the field names than you can use
COPY TO Myfile.csv DELIMITED
The Excel knows how to open CSV files.
>
>And if you give the target file the extension XLS, you can even open it in Excel, so that's *almost* cool. Unfortunately there's all those quotes and it stuffs all the data in the first column of cells.

In VFP 7 the following command creates a comma delimited file w/o double quotes
COPY TO Myfile.csv DELIMITED WITH "" with CHARACTER ,
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform