Take a look at APPEND FROM ... TYPE SDF and APPEND FROM ... TYPE DELIMITED. If your records are in fixed lenght or delimited format, you can use one of those command to append records to a table. Otherwise take a look at FOPEN(), FGETS(), FREAD(), FCLOSE() functions. The Filetostr() and Alines() could be also used for a small file.

>Hi,
> I have a data collecter machine which will take the stock by scan the barcode of the goods then download back to pc and save as a text file.
> Then i wish to programmatically to open the text file and read the record by record(line by line in text file). Then insert each record into my own table.
> I need help on how to open the text file and read each record line by line.
>thanks.
>
>kengwen