>I am creating a new table form an ASCII file. It contains 3 fields, 1 character and 2 Memo fields. How do you append from the ASCII to the memo field. Can it be done or is there a work-around? thanks for the help..
The safest way is to write procedure which will:
1. Open file and reading line by line (using FOPEN(),FGETS()).
2. Analyze each line and insert data into a table (using SUBSTR(), INSERT).
Don't forget to close ASCII file at the end (FCLOSE()).
Edward Pikman
Independent Consultant