How to Import dBase Database into SQL Server?

Updated on     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:

ODBC Data Sources

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

.Net Framework Data provider for ODBC

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

.Net Framework Data provider for ODBC

Step 4. Map and import your data.

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


SQL Server