I'm trying to connect Sql Server to an excel file and I'm using the following
in a query and getting the following error message...
Msg 15247, Level 16, State 1, Procedure sp_addlinkedserver, Line 26
User does not have permission to perform this action.
Msg 7202, Level 11, State 2, Line 2
Could not find server 'EXCEL' in sysservers. Execute sp_addlinkedserver to
add the server to sysservers.
-------------Here is what I was using.
EXEC sp_addlinkedserver EXCEL,