我这个数据库操作有错吗?
dim CnnSubway As ADODB.Connection
Set CnnSubway = New ADODB.Connection
CnnSubway.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" + App.Path + "\subway.mdb"
CnnSubway.Open
CnnSubway.Execute "insert into tblDssHist(no,station_no,instn_am,data_type) values (2,1,31495,0)"
cnnsubway.close
set cnnsubway=nothing
总是提示SQL语句语法错误。郁闷