CODEWITHSUNDEEP
sql-serverfoxprodbf
Pop Catalin
Pop Catalin

Reputation: 62920

How to import a DBF file in SQL Server

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

Upvotes: 18

Views: 105776

Answers (5)

mark d
mark d

Reputation: 136

I was able to use the answer from jnovation but since there was something wrong with my fields, I simply selected specific fields instead of all, like:

select * into CERTDATA
from  openrowset('VFPOLEDB','C:\SomePath\CERTDATA.DBF';'';
    '','SELECT ACTUAL, CERTID,  FROM CERTDATA')

Very exciting to finally have a workable answer thanks to everyone here!

Upvotes: 6

jnovation
jnovation

Reputation: 21

What finally worked for us was to use the FoxPro OLEDB Driver and use the following syntax. In our case we are using SQL 2008.

select * from 
    openrowset('VFPOLEDB','\\VM-GIS\E\Projects\mymap.dbf';'';
    '','SELECT * FROM mymap')

Substitute the \\VM-GIS... with the location of your DBF file, either UNC or drive path. Also, substitute mymap after the FROM with the name of the DBF file without the .dbf extension.

Upvotes: 2

Stan
Stan

Reputation: 21

http://elphsoft.com/dbfcommander.html can export from DBF to SQL Server and vice versa

Upvotes: 2

GateKiller
GateKiller

Reputation: 75869

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

Upvotes: 0

SQLMenace
SQLMenace

Reputation: 134941

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

Upvotes: 19

Related Questions