-----Original Message-----
From: profoxtech-bounces AT leafe D.O.T com [mailto:profoxtech-bounces@leafe.com]
On Behalf Of Peter Cushing
Sent: Wednesday, January 31, 2007 11:37 AM
To: profoxtech AT leafe D.O.T com
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]
©2007 Judith Barer |
