INSERT DATA FROM EXCEL TO SQL TABLE USING SINGLE QUERY

//POSETED BY SURESH CHAND JANGID

INSERT INTO SQLTableName(C1, C2, C3, C4, C5)
SELECT C1, C2, C3, C4,GETDATE()
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\MSSQLTips\Examples.xls;',
'SELECT C1, C2, C3, C4 FROM [Sheet1$]')