excel导入到数据库中
insert into Table_Teacher select convert(bigint,编号) ,姓名,年级,班级,科目,问卷调查 FROM OpenRowSet('MICROSOFT.JET.OLEDB.4.0', 'EXCEL 5.0;HDR=YES;IMEX=1;DATABASE=" + filepath + "',Sheet1$)
表和excel的字段一样
insert into Table_Teacher select convert(bigint,编号) ,姓名,年级,班级,科目,问卷调查 FROM OpenRowSet('MICROSOFT.JET.OLEDB.4.0', 'EXCEL 5.0;HDR=YES;IMEX=1;DATABASE=" + filepath + "',Sheet1$)
表和excel的字段一样