Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting to a Spreadsheet with Field Captions
Message
From
05/05/2004 13:36:26
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00901262
Message ID:
00901280
Views:
21
>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)


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform