How to define destination for an append query Microsoft Access
If MainTable has more that one colum (I guess it does), then you need to specify it like that:

INSERT INTO MainTable(ColumnName)


Also you have to specify the columns in the SELECT STATEMENT:

SELECT Column1, Column2
FROM TABLE2....