excel表和access中都有两个字段.主要代码如下: row = 1
Do
'获得excel数据并插入到access中
new_value = Trim$(excel_sheet.Cells(row, 1))
new_value1 = Trim$(excel_sheet.Cells(row, 2))
If Len(new_value) = 0 Then Exit Do
txtSQL = "INSERT INTO TestValues(num,name) VALUES (" & new_value & "," & new_value1 & ")"
db.Execute txtSQL row = row + 1
Loop但运行时有错,提示为"参数不足,期待是1".请问是哪的错?
当excel和access中都只有一个字段则正常
Do
'获得excel数据并插入到access中
new_value = Trim$(excel_sheet.Cells(row, 1))
new_value1 = Trim$(excel_sheet.Cells(row, 2))
If Len(new_value) = 0 Then Exit Do
txtSQL = "INSERT INTO TestValues(num,name) VALUES (" & new_value & "," & new_value1 & ")"
db.Execute txtSQL row = row + 1
Loop但运行时有错,提示为"参数不足,期待是1".请问是哪的错?
当excel和access中都只有一个字段则正常
或者
假设字段是字符串
txtSQL = "INSERT INTO TestValues(num,name) VALUES ('" & new_value & "','" & new_value1 & "')"