Importing Foxpro (*.dbf) files | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Importing Foxpro (*.dbf) files

Hello, Can I import MS Dos version of Foxpro files to sql server 2000? Regards,
Ali Aghabagheri
Yes, by using DTS and select the appropriate dbf driver (odbc) to recognize the files.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com
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.
]]>