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 |