EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE; GO EXEC sp_configure 'Ad Hoc Distributed Queries', 1; GO RECONFIGURE; GO INSERT INTO dbo.Reason_Mst (varReasonCode,varReasonDesc) SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 11.0;Database=\\Dbserver\DESKTOP REDIRECT\IT\vcsit26\Desktop\OPC-Masters.xls', 'SELECT * FROM [Reject_reason$]')
Error while importing from excel to sql server OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)