Source

-- Create VFP OLE DB linked server to DBC
sp_dropserver @server = 'VFPoledbDBC'
GO
-- Using OLEDB provider for VFP
sp_addlinkedserver @server = 'VFPoledbDBC',
   @srvproduct = 'VFP',
   @provider = 'VFPOLEDB.1',
   @datasrc = 'H:\Program Files\microsoft visual foxpro 8\Samples\Data\testdata.dbc',
   @provstr = 'Collating Sequence=MACHINE'
GO
-- Perform query
SELECT * FROM VFPoledbDBC...customer
-----------
-- Create VFP OLE DB linked server to Dbf's (free tables)
sp_dropserver @server = 'VFPoledbDbf'
GO
-- Using OLEDB provider for VFP
sp_addlinkedserver @server = 'VFPoledbDbf',
   @srvproduct = 'VFP',
   @provider = 'VFPOLEDB.1',
   @datasrc = 'H:\Program Files\microsoft visual foxpro 8\Samples\Data',
   @provstr = 'Collating Sequence=MACHINE'
GO
-- Perform query
SELECT * FROM VFPoledbDbf...customer

Линкед сервер
EXEC sp_addlinkedserver
        @server = 'FOX_ODBC',
        @provider = 'MSDASQL',
        @srvproduct = '',
        @provstr = 'Driver={Microsoft Visual FoxPro Driver};
UID=;SourceDB=C:\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;
Collate=Russian;Null=No;Deleted=No' ;

select  * from OPENQUERY(FOX_ODBC,'select * from C:\aaa;')

Экспорт и импорт данных from SQL.RU

EXEC sp_addlinkedserver
@server = 'FOX_OLEDB',
@provider = 'VFPOLEDB',
@srvproduct = '',
@datasrc ='\\fileserv\data\folder',
@provstr = 'Collating Sequence=Machine'

-- Using OLEDB provider for VFP
sp_addlinkedserver @server = 'test',
   @srvproduct = 'VFP',
   @provider = 'VFPOLEDB.1',
   @datasrc = 'H:\Temp',
   @provstr = 'Mode=Share Deny None;Password="";Collating Sequence=MACHINE'
-- Using OLEDB provider for ODBC
sp_addlinkedserver @server = 'test1',
   @srvproduct = 'VFP-ODBC',
   @provider = 'MSDASQL',
   @provstr = 'DRIVER=Microsoft Visual FoxPro Driver;UID=;
      Deleted=Yes; Null=Yes; Collate=Machine;BackgroundFetch=No;
      Exclusive=No; SourceType=DBF;SourceDB=h:\Temp'

exec sp_serveroption 'YUNIK\MSTEST', 'data access', 'TRUE'
exec sp_serveroption 'YUNIK\MSTEST', 'rpc', 'TRUE'
exec sp_serveroption 'YUNIK\MSTEST', 'rpc out', 'TRUE'
go
exec sp_helpserver 'YUNIK\MSTEST'