|
这是出错的代码, rsE!培训号.Value是从excel中取的值。运行后,提示:insert into 语句的语法错误
ssql = "insert into train_zdy "
ssql = ssql & "values ('" & rsE!培训号.Value & "','"
ssql = ssql & rsE!部门序号.Value & "','"
ssql = ssql & rsE!意见.Value & "','"
ssql = ssql & rsE!修改内容.Value & "','"
ssql = ssql & rsE!主办部门.Value & "','"
ssql = ssql & rsE!培训方式.Value & "','"
ssql = ssql & rsE!项目类别.Value & "','"
ssql = ssql & rsE!项目名称.Value & "','"
ssql = ssql & rsE!内容简介.Value & "','"
ssql = ssql & rsE!培训对象.Value & "','"
ssql = ssql & rsE!培训对象职等.Value & "',#"
ssql = ssql & rsE!开始时间.Value & "#,#"
ssql = ssql & rsE!结束时间.Value & "#,"
ssql = ssql & rsE!培训期数.Value & ","
ssql = ssql & rsE!培训人数.Value & ",'"
ssql = ssql & rsE!培训地点.Value & "','"
ssql = ssql & rsE!境内外.Value & "','"
ssql = ssql & rsE!人员分类.Value & "')"
CurrentDb.Execute ssql |
|