用 INSERT INTO 插入数据库出现错误
我往用ACCESS建的数据库插入数据,但我的数据库是在旧版本的Microsoft access下建的,我把它转换为当前版本就出现实时错误3343(不可识别的数据库格式),请问如何在当前版本的Microsoft access下建立的数据库中插入数据。谢谢
Dim dbS As Database
Set dbS = OpenDatabase(App.Path & "\" & NU & "\" & B1 & ".mdb")
dbS.Execute " INSERT INTO JL " _
& "(时间,内温℃,内压Mpa,外温℃,外压Mpa,硫化信号,轮胎编号) VALUES " _
& "(" & MyStr & "," & d1y(NU) & "," & d2y(NU) & "," & d3y(NU) & ", " & d4y(NU) & " ," & d5y(NU) & " ," & d6y(NU) & " );"
dbS.Close