1. Linked sever для DBF файлов через ODBC DSN
sp_addlinkedserver @server = 'MyLinkedServer' , @srvproduct = 'Blah_blah', @provider = 'MSDASQL', @datasrc = ' User or System DSN '

2.Linked sever для DBF файлов через ODBC connection string
sp_addlinkedserver @server = 'MyLinkedServer' , @srvproduct = 'Blah_blah', @provider = 'MSDASQL', @provstr = ' connection string '

3. Linked sever для DBF файлов через Jet.OLEDB
EXEC sp_addlinkedserver @server = 'MYDBFs', @provider = 'Microsoft.Jet.OLEDB.4.0', @srvproduct = 'OLE DB Provider for Jet', @datasrc = 'C:\', @provstr = 'dBASE IV'

А еще в описании процедуры sp_addlinkedserver в BOL есть прекрасная таблица с описанием того, как и чем нужно заполнять соответствующие параметры для каждого провайдера.

2qwertiry
" Microsoft® Windows 2000 includes Microsoft Internet Information Services (IIS) and Microsoft Indexing Service version 3.0 . These services enable filtering files based on their properties and performing full-text indexing and retrieval of file data. ( For Microsoft Windows NT® 4.0 systems, the Windows NT 4.0 Option Pack includes IIS 4.0 and Microsoft Indexing Service 2.0. )

"To create a linked server to access an Indexing Service full-text index

1.Create the full-text index using Indexing Service. By default, Indexing Service installs a catalog named default. For more information, see the Indexing Service documentation.

2.Execute sp_addlinkedserver to create the linked server, specifying MSIDXS as provider_name, and the name of the full-text index as data_source.
For example, to create a linked server named FTIndexWeb that accesses a full-text index named Web, execute:

sp_addlinkedserver @server='FTIndexWeb', @srvproduct='Index Server', @provider='MSIDXS', @datasrc='Web'

3.The security authorization of Indexing Service clients is based on the Windows account of the process consuming the OLE DB Provider for Microsoft Index Service. Distributed queries are run in the context of the Microsoft SQL Server™ 2000 process. Because SQL Server typically runs under an account that has a high level of authorization, some SQL Server users use an Indexing Service linked server to access information that they are not authorized to access. Members of the sysadmin fixed server role address this problem by strictly controlling the SQL Server logins that are authorized to perform distributed queries using an Indexing Service linked server.
The administrator first uses sp_droplinkedsrvlogin to remove all login mappings to the Indexing Service linked server, for example:

sp_droplinkedsrvlogin FTIndexWeb, NULL

The administrator then uses sp_addlinkedsrvlogin to authorize individual logins to access the linked server, for example:

sp_addlinkedsrvlogin FTIndexWeb, true, 'SomeLogin'

To perform these actions, right-click the linked server in SQL Server Enterprise Manager, click Properties, and then select the Security tab.

In addition, ad hoc access to the OLE DB Provider for Microsoft Indexing Service using OPENQUERY can be disabled by setting the provider option DisallowAdhocAccess. "

2MadDog
Есть список только из своего личного опыты
dBASE IV - для доступа к .dbf фалам без memo полей
Text - для доступа к текстовым файлам
Excel 5.0 - для доступа к Excel файлам