title: how to solve the error The OLE DB provider "Microsoft.Jet.OLEDB.12.0" has not been registered. when trying to extract data from excel
body: <p>I have an excel file that is sitting on my C drive and I would like to know how I can extract that data row by row validate it and insert into a sql table using openrowset. This is my query below</p>
  
  <pre><code>select * into crm_marketingdbclients_temptable FROM OPENROWSET('Microsoft.Jet.OLEDB.12.0', 'Excel 12.0;Database= ;C:\Temp\HighEarners.xlsx;;HDR=YES', 'SELECT * FROM [Sheet1$]')
  </code></pre>
  
  <p>I run this query and I keep getting an error that reads "The OLE DB provider "Microsoft.Jet.OLEDB.12.0" has not been registered." I am using office 365 on a 64 bit machine</p>