>I deal with a proprietary software program that can use dbf files greater than 2GBs. I have been using VFP to retrieve data from SQL Server to produce dbfs for this software to use. The software can merge smaller dbfs into larger ones, but this is inconvenient. Does anyone know of a way to get data from SQL Server into a dbf that won't limit the size of the dbf to 2GBs. Thanks.

You can also check product called CodeBase at http://www.codebase.com/products/. According to there site "the maximum theoretical table size that can be supported is 4.2 million terabytes".