title: Openrowset function failure
body: <p>I'm executing this openrowset function:</p>
  
  <pre><code>SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
      'Excel 12.0;Database=C:\Users\JCPABALAN\Desktop\Data Migration\ListOfDiscards.xlsx;HDR=YES', 
      'SELECT * FROM [Sheet1$]')
  </code></pre>
  
  <p>But it gave me the following error</p>
  
  <blockquote>
    <p>OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "The Microsoft Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly. If 'Sheet1$' is not a local object, check your network connection or contact the server administrator.".<br>
    Msg 7350, Level 16, State 2, Line 1<br>
    Cannot get the column information from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".</p>
  </blockquote>
  
  <p>I have already set the <code>Ad Hoc Distributed Queries</code> into 1 and I Installed <code>Microsoft ACE</code> and also executed this line of code:</p>
  
  <pre><code>EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1 
  GO 
  EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1 
  GO
  </code></pre>
  
  <p>But it still won't work.</p>