I believe this goes back to dBase compatibility and these commands do the same thing.
It's not too hard to roll your own CSV/Tab delimited file in which case you can keep your memo fields mostly intact. You will need to convert embedded CRLF in order to keep one record per line. -- rk -----Original Message----- From: ProfoxTech <[email protected]> On Behalf Of Tracy Pearson Sent: Wednesday, October 30, 2019 10:08 AM To: [email protected] Subject: RE: Exporting Tables Gene, I have not seen a difference in the output of the two commands. You might want to consider looking at Craig Boyd's post about exporting and importing from Excel. It doesn't mention Memo fields that I could see. https://www.sweetpotatosoftware.com/blog/index.php/2008/09/30/using-excel-20 07-file-formats-in-vfp-9-0/ HTH, Tracy -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Gene Wirchenko Sent: Wednesday, October 30, 2019 9:58 AM To: [email protected] Subject: Exporting Tables 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 _______________________________________________ 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/dm6pr10mb340118e9b10819669a565284d2...@dm6pr10mb3401.namprd10.prod.outlook.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.
