One trick would be to create a HTML file with the memo field in it, but
give the file a "XLS" extension. Then, when the file is opened, Excel
will convert the HTML code into native format and display the content
for the user.
Live from Fox Forward, this is Kevin Cully reporting. <g>
Kevin Cully
CULLY Technologies, LLC
Sponsor of Fox Forward 2006!
http://foxforward.net
Peter Cushing wrote:
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.
[excessive quoting removed by server]
_______________________________________________
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.
