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....

Answer 1

Try the following steps:

1.Create ODBC Data Source to DBF file

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

3.Choose Data provider for ODBC as data source

4.Map and import your data