If you are just importing excel into SQL Server its better to do it using Management Studio.
Sean On Dec 28 2009, 1: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
