SQL INSERT

[gustaf111]

Hello,

How should I write the SQL string to insert a string into a database ? I write this statement to insert values:

strSQL = "INSERT INTO Table1 (Test) VALUES (" & 132123 & ");"

Gustaf

 

[guitarzan]

If you want to insert a hardcoded string, use this:

strSQL = "INSERT INTO Table1 (Test) VALUES ('132123');"

If your string is stored in a variable, use this:

MyVar = "132123"
strSQL = "INSERT INTO Table1 (Test) VALUES ('" & MyVar & "');"

Well, actually no... if your variable has single quotes, your SQL statement will be messed up (Google "SQL Injection")... you should replace single quotes with two single quotes like this:

MyVar = "132123"
strSQL = "INSERT INTO Table1 (Test) VALUES ('" & Replace(MyVar, "'", "''") & "');"