I've not tried it myself, but try this...

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

Get more information here...

http://support.microsoft.com/?kbid=321686

Hope that helps!