title: Get Excel sheet into temp table using a script
body: <p>Im trying to get this excel sheet into a table, so I can apply select statements to it etc, to update tables with its info.</p>
  
  <pre><code>SELECT * 
  FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
            'Excel 8.0;Database=C:\PB.xlsx',
            'SELECT * FROM [Sheet1$]')
  </code></pre>
  
  <p>Im running 64 bit machine.
  No idea what excel version it is.</p>
  
  <p>Error:</p>
  
  <blockquote>
    <p>Msg 7399, Level 16, State 1, Line 1
        The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
        Msg 7303, Level 16, State 1, Line 1
        Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".</p>
  </blockquote>
  
  <p>When I change to Excel 12.0;</p>
  
  <blockquote>
    <p>OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".
        Msg 7303, Level 16, State 1, Line 1
        Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".</p>
  </blockquote>