The error that I was getting was too many line continuations, so I removed them as much as possible and it works.
However, I have another problem which is regarding sql queries.
I hope someone may be of assistance :)
Is it possible to append 2 tables and each has a different number of fields.
example the table I want to append to (new_mbook) has 59 fields; however the table I want to append from (current) has more than 59.
I do NOT want to append ALL the fields from current, I want to append specific fields.
This is how I'm doing it (simplified version):
strSql = "INSERT INTO " & toTableName & "(" & FieldName & ", " & FieldName2 & ")" & _
" SELECT " & "[" & frmTableName & "]." & FieldName & ",[" & frmTableName & "]." & FieldName2 & _
" FROM " & frmTableName & ";"
Please note that the FieldNames have the same names in both tables.
(In both new_mbook and current the field names are the same for example CLAS_DESC)
Thank you for your help :)