>Dears,
>
>I am trying to manipulate a very large text file with VFP, my way is by creating a temporary single table and appending that text file into it.
>
>is there any other way or maybe any specific command within VFP to read the text file without appending it into a table.
>
>
>Tia,
>Andreas.

Andreas

If you don't have VFP 6, the following will read the file into a string varable.

LOCAL wholefile, handle, fileeof, filebof
STORE FOPEN('c:\yourfile.txt') TO handle    && Open the file
STORE FSEEK(handle, 0, 2) TO fileeof 	    && Move pointer to EOF
STORE FSEEK(handle, 0) TO filebof           && Move pointer to BOF
IF fileeof <= 1                             && Is file empty?
	WAIT WINDOW 'This file is empty!' NOWAIT
	wholefile = ' '
ELSE  && If not empty
	wholefile = FREAD(handle, fileeof)  && Store to memory
ENDIF
= FCLOSE(handle)                            && Close the file

HTH