Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
EXPORT and COPY commands add field name to exported file
Message
From
23/06/1997 14:39:26
 
 
To
23/06/1997 13:14:44
Jody Cairns
OAO Technology Solutions
Moncton, New Brunswick, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00037457
Message ID:
00037474
Views:
31
> Using VFP 5.0: > > The following is documented behavior, as stated in > http://www.microsoft.com/kb/articles/q109/8/44.htm. > > The EXPORT and COPY TO commands, when used with spreadsheets (I use them > with TYPE XL5), add the table's field name to the first row of each > spreadsheet. > > Thus, if I had a table with a field name of FIELD_1, with one record having > the value 'testing', and I EXPORTed it using EXPORT TO tmp TYPE XL5, the > spreadsheet would have FIELD_1 in the first row, and 'testing' in the > second. > > Has anyone come up with any methods to avoid this? I do NOT want the > table's field names exported, too. Actually, it's all versions of FoxPro that export the field name. The only way around this is to remove the first row, and the easiest way may be through DDE (assuming no user intervention). Since I've not done DDE to Excel, I'll leave the rest of the details to the rest of the crew here. /Paul
Paul Russell
EMail: prussell@fox.nstn.ca
Phone: (902) 499-5043
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform