[2005] better codeing

[ikaris69]

not sure what to call this so sorry for the title

ok say i have 10 variables
var1
var2
var3
var4
var5
var6
var7
var8
var9
var10

ok each of them needs to be processed into sql

so

'im just gonna write sql statement to much to write connection and everything
 
 
sql = "insert into table (jason) values (" & var1 & ")"
sql.execute
 
sql = "insert into table (jason) values (" & var2 & ")"
sql.execute
 
sql = "insert into table (jason) values (" & var3 & ")"
sql.execute
 
sql = "insert into table (jason) values (" & var4 & ")"
sql.execute
 
sql = "insert into table (jason) values (" & var5 & ")"
sql.execute
 
.......
.........
..........so on and so on

in my actual project it is much more complicated but thats the jist of it

now is there an easier way of doing this?
like doing a for loop 10 times or something. if i did a loop i dont know how to change the var name to be based off the loop tho.

anyways thanks for your help in advance.

-JLR