Not sure if this applies, but i had trouble doing an SQLvar1 = "INSERT INTO tablename1 (field1) VALUES ("'& aspformvar1 &'")"
This shows the syntax i was looking for.
it's the asp var name from a submitted form, inside an & on each side, inside single quotes, inside double...