Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\new\template.xls;', 'SELECT * FROM [Sheet1$]') select * from School
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)