Philip B wrote:
I am having a problem exporting a dbf to an excel sheet with memo
fields...
is there a problem with exporting memo fields to excel?
I have used:
EXPORT FIELDS purno, vendno, company, amtopen,
purdate,reqdate,notes TO &lc_ExcelFile. TYPE XL5
and
COPY TO (lc_ExcelFile) FIELDS purno, vendno, company, amtopen,
purdate,reqdate,notes TYPE XL5
Neither one exports the <<NOTES>> field which is a memo..
You can't export them directly. Perhaps you could select out
left(<memofield>,250) plus the other fields from your table, then COPY
TO ... TYPE XL5.
Can't remember how wide a char field can be (and probably depends on
your VFP version.
Peter.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** 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.
