main logo
Subject: Re: csv files and memo fields
Author: Peter Cushing
Posted: 2007/01/31 11:37:17
 
View Entire Thread
New Search


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




 
©2007 Peter Cushing
<-- Prior Message New Search Next Message -->