Linked Servers and Excel | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Linked Servers and Excel

should i have a linked server called ExcelSource that points to a spreadsheet C:ForSQL.xls and i get error:
OLE DB provider ‘Microsoft.Jet.OLEDB.4.0’ reported an error. Authentication failed.
[OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]
OLE DB error trace [OLE/DB Provider ‘Microsoft.Jet.OLEDB.4.0’ IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].
is there a security option i need to change, i am the only one who would be hitting this linked server and spreadsheet (as it is on my computer) Joe Janka
http://support.microsoft.com/default.aspx?scid=285833
]]>