I can get the data to import through SQL 2005 using the following code:
select * openrowset ('VFPOLEDB', 'C:\Temp'; ' '; ' ','select * from dbfdata')
However, I need to be able to import the dbf data using SQL 2012.
But when I run the same command in SQL2012 I get the following error message:
The 32-bit OLE DB provider "VFPOLEDB" cannot be loaded in-process on a 64-bit SQL Server.
The only providers listed under Linked Servers are as follows:
I would love to get this working under SQL 2012. Any feedback would be greatly appreciated.