How to convert Visual Foxpro database into SQL Server database

Question

One of my clients has a Foxpro database (.DBF file). I need to convert it into a SQL Server 2008 database.

Does anyone have any idea how to do this? Kindly give me solution.

Thanks in advance....

Andrey Morozov · Accepted Answer

Try the following steps:

1.Create ODBC Data Source to DBF file

enter image description here

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

enter image description here

3.Choose Data provider for ODBC as data source

enter image description here

4.Map and import your data

enter image description here

Donate For Us