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