How to Import dBase Database into SQL Server?

Updated on July 5, 2016     Kisan Patel

Problems:

How to convert Visual Foxpro database into SQL Server database?
How to Import dBase Database into SQL Server?
Import dbase (dbf) Files using SQL Server.

Solution:

Try the following steps:

Step 1. Create ODBC Data Source to DBF file.

Go to => Control Panel => Administrative Tools => ODBC Data Sources => then create new ODBC Data Source as shown in screenshot:

Step 2. Using SQL Server Import Data Wizard (right click to database in the SSMS)

Step 3. Choose .Net Framework Data provider for ODBC as data source.

Step 4. Map and import your data.

Source:
http://www.sql-server-performance.com/2011/import-dbf-files/