Export data file into dbf format...

Hi all, I need to export/generate a data file in dbf format from SQL Server 2000 table. I wonder how can this be done inside SQL Server 2000? Would DTS helps? Please advise.

Thanks,

TM

You need to have the correct drivers (assuming this is a FoxPro file) installed and you can use DTS...|||Hi TM,

There are several ODBC drivers and OLE DB data providers you can use to create the DBFs. You can use Jet, the latest FoxPro and Visual FoxPro ODBC driver, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates/odbc, or use The latest FoxPro and Visual FoxPro OLE DB data provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates.

Jet will create DBFs in the older Dbase IV format. Over the years, new data features have been added to the Fox DBF structure. These new features are not compatible with Jet and will not open natively in Excel, for example. The Fox ODBC and OLE DB will create VFP-compatible DBFs in the newer format.|||Thanks to Cindy & Dan...