>I have to create a table of 35 millions plus records. The table is to be populated from 850 fixed length text files. I get about 1/3rd of the way through with the imports and I hit the 2 Gig limit for Visual FoxPro tables.
(I'm taking this in bits.) For the issue of database size, you might be interested in this article Val Mattison wrote for Advisor on the subject:
http://advisor.com/Articles.nsf/aidp/MATIV02. Someone found the ref for me when I was looking for info on the Chunnel.