-- 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' >>Be advised that in my tests the linked server to VFP free tables that uses OLEDB provider for ODBC was considerably faster.