Link to home
Start Free TrialLog in
Avatar of programmerist 1983
programmerist 1983Flag for Türkiye

asked on

how can i solve “The OLE DB provider ”Microsoft.Jet.OLEDB.4.0“ has not been registered.”?


  i try to use get excel data from excel file. i am using office 2007 and sql 2005. i writed below codes:
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$]') 

Open in new window


Error:Msg 7403, Level 16, State 1, Line 2 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
How can i solve it?
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

ASKER CERTIFIED SOLUTION
Avatar of SinghAmandeep
SinghAmandeep

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of programmerist 1983

ASKER

How can i write my codes like your codes? i can not rearrange it?
How can i send data from Excel to sql?
Have you tried installing latest Jet Driver from the links I posted above..
And we can only hope you are not using SQL Server 2005 64-bit...
If you are trying to send Data from Excel to SQL 2005, why dont you try it the other way round

Create an SSIS package in SQL and call it when needed,
its very simple to do so, just use the normal import/export wizard and save your package and your done.

then all you have to do is just call your dtsx package

Regards
I'm thinking along the same lines as acperkins...
This sounds like you've got a 64-bit version of SQL Server.  If so, you'll have to install the new 64-bit version of the Microsoft Access Database Engine 2010 drivers.  This is the replacement for the OleDB/Jet drivers which are not available as 64-bit versions.
http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en