Use
OPENDATASOURCE [
^]to select data from your Excel file:
SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\temp\Excel.xls;Extended Properties=EXCEL 5.0')...[Sheet1$] ;
If you want to import data from Excel into a new table use INTO syntax:
SELECT * INTO excelTable FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\temp\Excel.xls;Extended Properties=EXCEL 5.0')...[Sheet1$] ;