Gene
If CSV is acceptable to you, you may try the CSVProcessor class at VFPX.
m.CSV = CREATEOBJECT("CSVProcessor")
m.CSV.Export("output.csv")
Whatever memo fields are on your table, they will be exported, as well.
You may also consider using one of the XLSX classes available at VFPX.
On Wed, Oct 30, 2019 at 1:58 PM Gene Wirchenko <[email protected]> wrote:
> Hello:
>
> I am having to do a bunch of data export so have had a closer
> look at the commands.
>
> 1) I am wondering if there is a difference between
> <vfp>
> COPY TO ... TYPE ...
> </vfp>
> and
> <vfp>
> EXPORT TO ... TYPE ...
> </vfp>
> where the type is XLS or XL5.
>
> 2) I know that memo columns are not exported so for tables with
> them, I am creating a cursor with the memo columns replaced with
> C(254) columns. In a few cases, this will result in data being
> clipped. Short of programming my exports to use Office Automation,
> is there a way around this? (I mean that is not a kludge. For
> example, I could create multiple columns each with a piece of the
> memo, but that would be horribly ugly.)
>
> Sincerely,
>
> Gene Wirchenko
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/CADj74tG3Jh3pA+uz3ixQNTVD5=4hbxynw7xzgsqtq-rrirr...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
