syntaxhelp.com Your online cheat sheet!

Creating a linked server to Excel

-- Linked Server Name: ExcelData
-- Excel File: c:\temp\data.xls
EXEC sp_addlinkedserver 
  'ExcelData',
  'Excel',
  'Microsoft.Jet.OLEDB.4.0',
  'c:\temp\data.xls',
  NULL,
  'Excel 8.0',
  NULL

Creating a linked server to Excel 2007

-- Linked Server Name: ExcelData
-- Excel File: c:\temp\data.xls
exec sp_addLinkedServer
  @server= 'ExcelData',
  @srvproduct = 'ACE 12.0',
  @provider = 'Microsoft.ACE.OLEDB.12.0',
  @datasrc = 'c:\temp\data.xls',
  @provstr = 'Excel 12.0; HDR=No'

Creating a linked server to Oracle

-- Linked Server Name: OraData
-- Oracle Server Address: OraSrvr
EXEC sp_addlinkedserver 
  'OraData', 
  'Oracle', 
  'MSDAORA', 
  'OraSrvr'