>I am working for a large company that recently merged with another large company. They were both storing data in very large text files. In some ultimate wisdom due to the merger the result is that the data will be combined into an even larger text file with a record length of 78,000+. Considering tha the VFP maximum record length for text files is 65535, does anyone have any suggestions as to how I could read such a file and use it in VFP? The current recod length is approx. half that. All I do with this file is open it and remove certain pieces of it into a table for processing. Any ideas?
>
>Thank You!
How many bytes is "Obnoxious"?
In any case you'd have problems with that file. If file size is less than 2Gb then you have a chance to do that with lowlevel functions. Do not use fgets() but fread() to read (documented but still is a bug IMHO).
78000 bytes is above a record's allowed size. You may need to parse parts of it into memo fields.
SQL server express is for free and I think it is worth to get help from SQL server for doing the transfer.
Cetin