[MSSQL] Import Excel Using Query

Below example how to import row data directly using queries. 

SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

Tested on MSSQL 2005.

Reference: http://support.microsoft.com/kb/321686