On Wed, Oct 30, 2019 at 9:58 AM Gene Wirchenko <[email protected]> wrote: > 1) I am wondering if there is a difference between > where the type is XLS or XL5. >
Nope, according to: https://www.tedroche.com/hackfox7/s4g059.html "Both COPY TO and EXPORT copy selected data to another file. We can't see much reason to use EXPORT, since COPY TO can do everything it does and more. (In fact, we're fairly convinced EXPORT exists only because IMPORT does.)" > 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.) > For some projects, I created a textmerge file, named it something.CSV and use textmerge to export the PK and commas and text delimiters and the memo fields. Rejoining the two data sources was left as an exercise for the receiver. Be wary of the need to escape text delimiters if used within the memo field, i.e., O'Reilly or "Sold "As Is" " -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/CACW6n4sOwakyP9syC5r4FGJ_poJPQ=uwgf0kpybhqddtqxa...@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.
