vb6向access中写入数据问题
airob 2016-12-06 10:12:38 Dim cnn1 As ADODB.Connection
Dim strCnn As String
Set cnn1 = New ADODB.Connection
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\history.mdb;Persist Security Info=False"
cnn1.Open strCnn
name = rstSchema!Table_Name
id = Right(rstSchema!Table_Name, 5)
testtype = "FVC"
testdate = Right(FILE_NAME_TEMP, 14)
review_n = txtREVIEWN.Text
review_d = txtREVIEWD.Text
cnn1.Execute "Insert Into name(ReportId,TestType,TestDate,ReviewN,ReviewD) values(id,testtype,testdate,review_n,review_d)"
这样写,最后一条写入数据的命令报错,其中name,id,testtype,testdate,review_n,review_d这几个都是字符串变量,希望将id,testtype,testdate,review_n,review_d的内容写到access中的name(name也是字符串变量,其内容是想要存入的文件名)文件中,怎么写?
vb小白,真心求教!不胜感激!
cn.Execute"INSERT INTO test(id,name) VALUES ('001','张三')"
这种写法我懂,关键是文件名和想要写入的数据都在字符串变量中,就不知道怎么操作了。谢谢大神们!