How to import a DBF file in SQL Server
Use a linked server or use openrowset, example
SELECT * into SomeTableFROM OPENROWSET('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceDB=\\SomeServer\SomePath\;SourceType=DBF','SELECT * FROM SomeDBF')
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 CERTDATAfrom openrowset('VFPOLEDB','C:\SomePath\CERTDATA.DBF';''; '','SELECT ACTUAL, CERTID, FROM CERTDATA')Very exciting to finally have a workable answer thanks to everyone here!