INSERT INTO Query

[Comfy]

I have Database1 – Table1 which contains 4 columns
I also have Database2 – Table2 with 5 columns (4 of which are the same as Table1)

Currently I am running an Insert Query in Table1 to copy the data to Table2, then run an update Query in Table2 to populate the 5^th column (Numerical Value representing a Financial Period)

Is it possible to append this 5^th column to my Insert Query?

INSERT INTO [Table2] IN 'C:\Database2.accdb'
SELECT *
FROM [Table1]
WHERE ((([Table1].MonthNo)=[Month to Export]));