i want to split my sql statement into 2 lines(right before "values", what is the syntax for it?
i try : sql = "insert into tbl1 ( )spaceunderscore
values ()

it didn't like it.

eg.

sql = "insert into tbl1 () values ()"

thanks

sql = "insert into tbl1 ( )" & vbCrLf
sql = sql & "values ()"

I never use the line splitting thing, but I think you could also use:

sql = "insert into tbl1 ( )" _
& "values ()"

sql = "insert into tbl1 ( )" & _
     " values ()"

thanks a bunch