Import Excel data into SQL Server 2005 table using distributed queries

/*SQL server configuration settings */

exec sp_configure

sp_configure ’show advanced options’, 1

reconfigure

exec sp_configure ‘Ad Hoc Distributed Queries’, 1

reconfigure

/*Excel import into sql table  using distributed query*/

select * into XLimport from

openrowset(‘Microsoft.Jet.OLEDB.4.0′,

‘Excel 8.0;Database=C:\Documents and Settings\Administrator\Desktop\filename.xls’

,[Sheet1$])

select * from XLimport