I have a SQL "INSERT" statement that works in a query, but does not work in VBA. I'm getting no errors. Can anyone see what's wrong ? See below . . .
VBA
strCheckNumber = 455
strSQL = "INSERT INTO [Table_Check_Number_List] (CheckNumber) VALUES ( " & strCheckNumber & ")"
Query
INSERT INTO [Table_Check_Number_List] (CheckNumber) VALUES (455)
VBA
strCheckNumber = 455
strSQL = "INSERT INTO [Table_Check_Number_List] (CheckNumber) VALUES ( " & strCheckNumber & ")"
Query
INSERT INTO [Table_Check_Number_List] (CheckNumber) VALUES (455)
Last edited: