programmerist 1983
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$]')
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How can i write my codes like your codes? i can not rearrange it?
ASKER
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
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
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
http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en
and if that is not working, then try installing this.
http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en