[SQL Server] import an Excel file to an SQL Server database table

/*
Office 2003
If the table to be imported already exists:
*/
Insert into demotable
Select *
From OpenRowSet
(
'Microsoft. Jet. oledb.4.0'
, 'Excel 5.0; HDR = yes; database = D: \ demo.xls'
, Sheet1 $
)
/*
If you import data and generate a table:
*/
Select * into demotable
From OpenRowSet
(
'Microsoft. Jet. oledb.4.0'
, 'Excel 5.0; HDR = yes; database = D: \ demo.xls'
, Sheet1 $
)

/* = */

/*
Office 2010
If the table already exists, the SQL statement is:
*/
Insert into demotable
Select *
From OpenDataSource
(
'Microsoft. Ace. oledb.12.0'
, 'Data source = D: \ demo.xlsx; extended properties = Excel 12.0'
)
... [Sheet1 $]

/*
If the table does not exist, the SQL statement is:
*/
Select * into demotable
From OpenDataSource
(
'Microsoft. Ace. oledb.12.0'
, 'Data source = D: \ demo.xlsx; extended properties = Excel 12.0'
)... [Sheet1 $]

Reproduced to: http://www.cnblogs.com/txst/archive/2011/04/21/2023372.html