How to import a DBF file in SQL Server

Question

How can you import a foxpro DBF file in SQL Server?

Answer 1

Use a linked server or use openrowset, example

SELECT * into SomeTable
FROM OPENROWSET('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;
SourceDB=\\SomeServer\SomePath\;
SourceType=DBF',
'SELECT * FROM SomeDBF')

Answer 2

This tools allows you to import to and from SQL Server.

• http://www.download3000.com/download_17933.html