INSERT INTO mobile(number,Charges,category,Price) SELECT number
,Charges,category,Price FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=E:\Book1.xls',sheet1$)
INSERT INTO mobile(number,Charges,category,Price) SELECT number
,Charges,category,Price FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=E:\Book1.xls',sheet1$)