See Re: Memory manager, how much memory Message #882003

>I am attempting to import records from a series of large (40,000,000+ records) text files, and am continually running into memory errors.
>
>When I attempted to append the records from one large file (or even from two or more into the same table), the error message was "Not enough memory for Filemap". When I pulled the files into a table in smaller groups (4-5 million at a time) and then tried to insert them from there into a second table (the ultimate goal was to pull certain data from the report while preserving the data line), the insert command would eventually error off with a message "Invalid Seek Offset", and the table into which I had been inserting records turns into toast.
>
>The first message indicates I have limited memory and suggests adding more memory, but we're getting out of my area, and I need some advice on how to proceed. The second message is scarier, as the Help file just says "Record your recent actions while using Visual FoxPro and then call Microsoft Support," like I need to be debriefed by the authorities.
>
>I am currently running one GB of RAM. Do I need more memory, or do I need to reallocate FoxPro's memory usage?