Import Excel data to SQL Server -


i want insert data excel file sql server.. used following sql statement:

select *    openrowset('microsoft.jet.oledb.4.0',                   'excel 8.0;database=y:\path.xls',                   'select * [sheet$]') 

but getting following error -

msg 7403, level 16, state 1, line 1
ole db provider "microsoft.jet.oledb.4.0" has not been registered.

you can use import data wizard of sql server instead.


Comments