How to import a DBF file in SQL Server

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

From stackoverflow Pop Catalin

• 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')
  

  From SQLMenace

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

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