Check this out:
http://support.microsoft.com/kb/321686 Benj On Dec 28, 9:17 pm, nag <[email protected]> wrote: > 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
