Excel导入SqlServer2005

INSERT INTO KFDA
select * from OpenDataSource
         ('Microsoft.Jet.OLEDB.4.0',
          'Data Source=D:\My Documents\历史档案\定稿\历史已核\Book1申重申.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"'
          )...[Sheet1$]