--SELECT * FROM [TABLENAME]
列名1,列名2,列名3,列名4,列名5
FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=路径\**.xls',Sheet1$) ---03版
--07版('Microsoft.Ace.OleDb.12.0','Excel 12.0;DATABASE=路径\**.xlsx','SELECT 列名1,列名2,... FROM [Sheet1$]')
INSERT INTO [TABLENAME]
(字段1,字段2,字段3,字段4,字段5)
SELECT列名1,列名2,列名3,列名4,列名5
FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=路径\**.xls',Sheet1$) ---03版
--07版('Microsoft.Ace.OleDb.12.0','Excel 12.0;DATABASE=路径\**.xlsx','SELECT 列名1,列名2,... FROM [Sheet1$]')