none
How to Export SQL to DBF

    Question

  • Hi,

        I have a simple SQL Server 2000 table and I want to export a query result to FoxPro .DBF Files. Is there any way to do using t-sql and not DTS? Whats the DTS solution? Cus I haven't been able to find one cus I need to do this automatically from an application in .NET.

    Thanks.
    Thursday, January 04, 2007 8:32 PM

Answers

  • Hi Fernando,

    You haven't said whether you need to create new tables or add data to existing tables.

    One way to export data is to set up a linked server using the FoxPro and Visual FoxPro OLE DB data provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates .

     

    Monday, January 08, 2007 3:19 AM

All replies

  • You can take help of DTS in this case to export data.
    Friday, January 05, 2007 11:09 AM
  • Hi Fernando,

    You haven't said whether you need to create new tables or add data to existing tables.

    One way to export data is to set up a linked server using the FoxPro and Visual FoxPro OLE DB data provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates .

     

    Monday, January 08, 2007 3:19 AM