title: how can i solve "The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered."?
body: <p>i try to use get excel data from excel file. i am using office 2007 and sql 2005. i writed below codes: </p>
  
  <pre><code>CREATE TABLE [dbo].[Addresses_Temp] (
      [FirstName]   VARCHAR(20),
      [LastName]    VARCHAR(20),
      [Address]     VARCHAR(50),
      [City]        VARCHAR(30),
      [State]       VARCHAR(2),
      [ZIP]         VARCHAR(10)
  )
  GO
  
  INSERT INTO [dbo].[Address_Temp] ( [FirstName], [LastName], [Address], [City], [State], [ZIP] )
  SELECT [FirstName], [LastName], [Address], [City], [State], [ZIP]
  FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
                  'Excel 8.0;Database=C:\Source\Addresses.xls;IMEX=1',
                  'SELECT * FROM [Sayfa1$]')
  </code></pre>
  
  <p><h3>Error:Msg 7403, Level 16, State 1, Line 2
  The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.</h3> How can i solve it?</p>