Access插入语句的奇怪问题
我用程序执行一行语句
strSql="insert into T_StaAuto(ST,TMSystem,TMCollection,Voltage,Memo,FrameCount,Flag)
values(2,'2005-12-27 10:57:02','2005-12-27 10:53:00',11.7339839935303,2122383875,9238,0)"
ExecuteSqlWithoutDS(strsql)
Public Function ExecuteSqlWithoutDS(ByVal strSql As String)
Dim myConnection As New OleDb.OleDbConnection(GetAccessConStr())
Dim myCommand As New OleDb.OleDbCommand(strSql)
myCommand.Connection = myConnection
'myCommand.Connection.Open()
myConnection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()
系统提示我 INSERT INTO 语句的语法错误。
可是这个语句放到access中的sql视图里面是可以执行成功的,究竟是怎么回事?
请大家帮忙诊断一下