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

Reply via email to