Unable to create stored procedure to access excel files in SQL Server?
The good news is it CAN be done.  The bad news is you are opening a security hole.


Create a new database for this SP.
Make the owner of the database a sysadmin.
Set the database to trustworthy
Create your SP in the database using EXECUTE AS OWNER
For the people you want to be able to run this grant ONLY the following permissions.


CONNECT (create them a user)
EXECUTE on the stored procedure.



The reason for moving it off to it's own database &amp; dramatically restricting permissions there I hope is fairly obvious.  By setting things up this way anyone who can run the stored procedure is in effect a sysadmin.  Now it's restricted to the code in the SP.  But what happens if someone gets db_owner access?  They can now write SPs that can grant them sysadmin.  Note: db_owner is a simple example.  There are lower permissions that could cause problems also.