Thanks, Alex.

Naturally, I already have the captions, via DBGETPROP(), for, as I said, they're meaningful to the user, whereas the field names aren't. They feature on the forms and in reports.

The problem is HOW to get them into the exported (or COPY TOed) file/table/worksheet, in the "export routine". I guess I'll have to manipulate the resultant s/s via automation, but i don't know about the text file. I guess the table is just as difficult as it's exported as a free table (there may be lots of these for archive), so won't support long field names of captions.

Terry


>>Hi Threaders
>>
>>I need to export my data to a spreadsheet, text file, and/or another VFP table. The thing is: I've got some very long, very descriptive field captions in the table and the "short" names are pretty meaningless to a user.
>>
>>Anyone know is there any way of exporting to a s/s (and indeed a text file or VFP table) but have the resultant column headings as the field captions instead of the fieldnames?
>>
>>TIA
>>
>>Terry
>
>I would think that as a start you could use DBGETPROP() to retrieve the Caption property of the table fields and use it in your export routine (either to text or spreadsheet)