Sorry but this is from help on limits

Table and Index Files
Maximum # of records per table file 1 billion
Maximum size of a table file 2 gigabytes
Maximum # of characters per record 65,500
Maximum # of fields per record 255
Maximum # of tables open at one time 2551
Maximum # of characters per table field 254
Maximum # of bytes per index key in a non-compact index 2 100
Maximum # of bytes per index key in a compact index 2 240
Maximum # of open index files per table unlimited1
Maximum # of open indexes in all work areas unlimited1
Maximum # of relations unlimited
Maximum length of relational expressions unlimited

Jeff

>I have (6) text files roughly 2GB each with about 20 million records in each file that we want to import into seperate tables and then union them into one table. I created an import program to scan thru using fgets and then parsing the string into about 9 fields and inserting into my table. After about 15.8 million records, I get a 1150 error code "Not enough memory for file map" and cannot continue. The table size is now about 2GB. I thought Foxpro's table restriction was a billion records and hard drive space. I added one record to the table and then closed it. Now when I try to open it FoxPro tells me that it is not a DBF file. Any thoughts?