-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Cushing Sent: Wednesday, January 31, 2007 11:37 AM To: [EMAIL PROTECTED] Subject: Re: csv files and memo fields
Judith Barer wrote: > Does anybody have an idea how I could generate a csv file programtically > that would include in it the info from memo fields. What would be the > simplest way to do this? > > I also would like to take a csv file and append it to a dbf file with > memo fields. I tried converting the file to a string using strtofile > and then using a alines but the file is so big that it generates a > subscript out of range error. I am using VFP 8.0. > >Hi Judith, >You can't do it directly as the option ignores memo fields. Copying to >a CSV you could select out say the first 250 chars of the memo field >(along with your other data) and then do a COPY TO with that data type CSV >If your csv file has been written in this format you can append into a >cursor with a field 250 chars for the memo, then insert this into your >proper memo field. >Peter I need to account for the field being bigger than 250 chars [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.
