vbscript如何把文本的內容插入數據庫
在vbscript中我這樣寫
set iCon = CreateObject("Adodb.connection")
set fso = CreateObject("Scripting.FileSystemObject")
set conTxt = fso.OpenTextFile("D:\2007-11\200803job\ProMessage\Files\MT003.txt",ForReading)
strCon = "UID=sa;PWD=123;Database=SAMMayDemo;" & _
"Driver={SQL Server};" & _
"Server=.;" & _
"Provider=SQLOLEDB.1;"
iCon.Open strCon
rs = conTxt.readline()
然後將rs讀出的內容某些部分再分配給另一變量aa,再通過SQL語句賦給一變量如
strSQL = “insert into 表(列名) values(aa)”
iCon.execute strSQL
為什麼不能插入呢?