title: OpenRowSet and OpenDataSet without sysadmin rights
body: <p>Is there any way to use the OpenRowSet and OpenDataSet commands in SQL Server 2008 R2 without having to have SysAdmin rights?</p>
  
  <p>I'm trying to load data from an Excel file and our service account that will do the actual loading can't have sysadmin rights.  </p>
  
  <p>It's currently not a linked "server" and the file name can change from month to month.</p>
  
  <p>Here is my query:</p>
  
  <pre><code>SELECT  
    Center,
    Amount 
  FROM OPENROWSET(
    'Microsoft.ACE.OLEDB.12.0'
    ,'Excel 8.0;HDR=NO;Database=C:\exceldata.xls'
    ,'SELECT 
        F1 as Center,
        F2 as Amount
     FROM [Sheet1$]')
  WHERE Amount &gt; 0
  </code></pre>
  
  <p>Thanks</p>