>Hi all,
>
>I have text files with lines of data and I wanted to copy them line by line to a memo field of a table, 1st line go to 1st record, 2nd line go to 2nd record. I have tried the following codes but somehow when the length of the line exceeds 50, it will append the following characters into 2nd record. Any idea?
>
>

>
>CREATE CURSOR lctest (mdata m)
>nline = MEMLINES(FILETOSTR(TRANSFORM(lcfile))) && lcfile = file name
>	
>FOR i=1 TO nline
>   INSERT INTO lctest VALUES (MLINE(FILETOSTR(TRANSFORM(lcfile)),i))
>ENDFOR
>
>

Youi could use ALINES() also

DEFINE CRLF CHR(13)+CHR(10)
LOCAL lcFile, lnFor, laLines, lnLines
CREATE CURSOR lctest (mdata m)
lcFile = FILETOSTR(TRANSFORM(lcfile))
lnLines = ALINES(laLines,lcFile, 0, CRLF)
	
FOR i=1 TO lnLines 
    INSERT INTO lctest VALUES (laLines[i])
ENDFOR