Import excel into sql server

[nag]

hi friend
i tried following query for importing excel file to sql

INSERT INTO magazine
SELECT *
FROM OPENROWSET('Provider=Microsoft.Jet.OLEDB.4.0',
'Database=E:animals.xsl;Excel 8.0;HDR=YES',
'SELECT [FirstName], [LastName]
FROM [Employee1$]')

i got following errors
Server: Msg 7403, Level 16, State 1, Line 1
Could not locate registry entry for OLE DB provider
'Provider=Microsoft.Jet.OLEDB.4.0'.
please help me rectify the error
or let me know any other way of importing excel table

tnx

[Benj Nunez]

Check this out:

http://support.microsoft.com/kb/321686

Benj

[SeanJC]

If you are just importing excel into SQL Server its better to do it
using Management Studio.

Sean