Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Generic Utility to Export VFP 7 Data to .txt File Requir
Message
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00732507
Message ID:
00735041
Views:
28
Bernado,

I * do * need to 'export' (and I use that word loosely) memo fields in addition to the character, number, data fields to a '.txt' ascii file.
Is my best (and maybe only) option to use low-level file functions like 'fputs'?

>The Utility allow to export any field on the table but keep in mind that memo filed don’t get exported, it also allows to select the type on the file you wish to export ie “XLS,CSV,TXT” also bear in mind that when exporting to XLS you can only export abut 16,000 records. It also allow to save a query for later use, you can save them on a share directory or a local directory. The queries are stored as ascii files.
>
>
>A few of the modification that I made to the utility include the ability to search on memo fields, a way to select the order of the result by column number, not only by it’s name ( so you can sort by “sum(your field)”, the ability to extract Day, Month or year out of a date field this to allow you to group by them. Etc.
>
>BDH
Regards,

Allan Coganovitch
allanc@proven-solutions.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform