SQL语句——将Excel文档导入数据表中

INSERT   game_riddles_content(content)  
  SELECT   *   FROM        
    OPENROWSET('Microsoft.JET.OLEDB.4.0','Excel   5.0;HDR=NO;Database=E:\riddle.xls', 'SELECT   *   FROM   [sheet1$B1:B298]')

转载于:https://www.cnblogs.com/nofliu/archive/2010/03/25/1695472.html