> 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