Trying to query a .dbf file e.g "Select * from somefile.dbf"
SQL Server 2008
I can't figure out what I need to do to accomplish this.
Various forms of linkedserver, but I can't anything to work.
I even installed vfpoledb on the server.
select * from openrowset('MSDASQL',
'DSN=Visual FoxPro Tables;
'select * from dbfTable')
OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 7
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)"
Can someone help me with some straight script to connect to this .dbf file?
Something similar to if say I was going to connect to .xls file:
(this is from another solution)
EXEC sp_addlinkedserver MyExcel,
--Set up login mappings (just ADMIN - jet wants something).
EXEC sp_addlinkedsrvlogin MyExcel, FALSE, NULL, Admin, NULL
--List the tables in the linked server (these are the worksheet names).
EXEC sp_tables_ex MyExcel
select * from myexcel...Sheet1$