On Wed, Oct 30, 2019 at 9:58 AM Gene Wirchenko gene@shaw.ca 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" "