If there is lots of data, that will be SLOW and chew up memory and disk space fast.
>Perhaps you can use combination (as suggested earlier) of techniques. You can use FGETS() to read the file line-by-line, then use temporary table, but rather than using a character field, use a memo field. I do vaguely recall the original memory thread (though can't remember the exact details of what you were trying to do). I suspect you might've run into a problem if you were trying to read the entire file in one step using FILETOSTR(). Although ALINES() could be used, it also runs the risk of crashing if the file contained enough lines to cause array to contain too many elements (>65000 elements). Using FGETS() to read the file line-by-line would get around that problem.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer