SP_CONFIGURE 'AD HOC DISTRIBUTED QUERIES' ,1 GO RECONFIGURE go insert into temp_adhoc_arihant ( userid, starttime, endtime ) select * from openrowset ('MICROSOFT.JET.OLEDB.4.0','EXCEL 8.0; DATABASE=C:\Users\anurag.nayak\Desktop\sirumanual.xls','SElECT * FROM [DATA$]') GO --But i am getting error Cannot create an instance of OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)". I have restarted sql server. But same error. --How to fix it ?
Microsoft.ACE.OLEDB.12.0
Excel 12.0
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)