Insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\DynamicExcelFile16032012.xls','SELECT ProductID,ProductName,ProductDescription,ProductPrice,SupplierName FROM [ABC$]') EXEC ProductSearch @ProductName ='ABC'"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip