here is the append query
INSERT INTO tblInvoices ( Customer, BillingAddress1, BillingAddress2, BillingAddress3, InvoiceDate, Description, Terms, PONo, BillingEmail1, BillingEmail2, TotalAmount, GST )
SELECT tblAccounts.CompanyName, tblAccounts.BillingAddress1, tblAccounts.BillingAddress2...