>>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.

Nancy,

Thanks, I need to read this this evening. I had realized that there is no reason that I need to put all 35 million records into one table. It was just that when I saw that the whole thing would take up about 6 Gigs no matter how I sliced it, I realized that my real concern at the moment was pure file size. The file has to fit on a CD and be accessed directly from the CD. I would normally say that this is impossible but I'm looking at the fact that other vendors are apparently doing this. I just have no idea how or in what language they are working.

Ed