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]')
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]')