Hi,
I tried same code but still having same problem.
EXEC master.dbo.sp_addlinkedserver
@server = N'ExcelSource',
@srvproduct=N'Excel',
@provider=N'Microsoft.Jet.OLEDB.4.0',
@datasrc=N'E:\XlsDataSource.xls',
@provstr=N'Excel 8.0'
GO
Error Details:
---------------
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ExcelSource" returned message...