>>I need to write a program to daily process comma dilimited text files: re-arrange, aggrigate fields, etc, then write the results back into other similar files. Some of these files could have upto 400,000 records. I plan to use ADO, but never processed that many records from one text file. Any recommendations or things I should watch for?
>
>Is there a reason not to use VFP native tables for file manipulation? ADO is not going to perform as well as the native engine for a task where everything is being processed at the local system IAC for a VFP application - VFP seems well-suited to the process, and ADO doesn't seem to buy you anything, since there's no data engine behoind manipulating a text file.

Thanks for your reply. I may not be given the option to use VFP tables so I am seeing what straight ADO will do.