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
