[SQL Server] Excel檔案匯入SQL Server資料庫表

/*
    OFFICE 2003
    如果接受資料匯入的表已經存在:
*/
INSERT INTO DemoTable 
SELECT * 
FROM OPENROWSET
(
'MICROSOFT.JET.OLEDB.4.0'
    ,'Excel 5.0;HDR=YES;DATABASE=D:\Demo.xls'
    ,sheet1$
)
/*
    如果匯入資料並產生表:
*/
SELECT * INTO DemoTable  
FROM OPENROWSET
(
'MICROSOFT.JET.OLEDB.4.0'
    ,'Excel 5.0;HDR=YES;DATABASE=D:\Demo.xls'
    ,sheet1$
)

/*===================================*/

/*
    OFFICE 2010
    如果表已存在，SQL語句為：
*/
INSERT INTO DemoTable 
SELECT * 
FROM OPENDATASOURCE
(
'Microsoft.Ace.OLEDB.12.0'
    ,'Data Source=D:\Demo.xlsx;Extended Properties=Excel 12.0'
)
...[sheet1$]

/*
    如果表不存在，SQL語句為:
*/
SELECT * INTO DemoTable 
FROM OPENDATASOURCE
(
'Microsoft.Ace.OLEDB.12.0'
    ,'Data Source=D:\Demo.xlsx;Extended Properties=Excel 12.0'
)...[sheet1$]

轉載至：http://www.cnblogs.com/txst/archive/2011/04/21/2023372.html