SQL Server Performance

Importing Foxpro (*.dbf) files

Discussion in 'SQL Server DTS-Related Questions' started by aghabagheri, Oct 5, 2003.

  1. aghabagheri New Member

    Hello,

    Can I import MS Dos version of Foxpro files to sql server 2000?

    Regards,
    Ali Aghabagheri
  2. satya Moderator

    Yes, by using DTS and select the appropriate dbf driver (odbc) to recognize the files.


    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. ykchakri New Member

    Yes, I always do this. Create a DSN using the driver 'Microsoft Foxpro VFP driver', choose the Database type as 'Free Table Directory' and path as the path for the DBF files. Then choose this DSN as your source under DTS.

Share This Page