I have been searching for a few hours now with no luck so helpfully someone can help.

I have a Query that has the following headings:
Index ,Fund ,Fund Code ,Orgn ,Unit Code ,Acct ,GL_Type,TRANS DATE ,TYPE ,DOCUMENT ,DESCRIPTION ,DOC REF ,FLD ,AMOUNT ,Division , FY , SOURCE , Month, Period,

I have a blank table that has the following headings:
INDEX ,FUND ,Fund Code ,ORGN ,Unit Code ,Acct ,GL_Type ,TRANS DATE ,TYPE ,DOCUMENT ,DESCRIPTION ,DOC REF ,FLD ,AMOUNT ,DIVISION ,FY ,SOURCE ,Month ,Period ,RECON

The only fields in my table that will be unique to that table are the last field RECON

I pull a downloaded data set each week and the data only continues to grow meaning the records that I pulled last week would be in the download I pulled this week plus some new records. Each week I save the Excel spreadsheet in the same location overwriting the existing spreadsheet. I then have that spreadsheet pull into Access via a Linked Table I then have a simple query that just grabs the specific fields mentioned above. I now want to take that Query and append that the data that is in that query into my Master Table. I now use that Master table to reconcile against another data set and when I find an expense that exists in my other data set I type Reconciled in the RECON field in my table and I do this until every record has been reconciled. Next week I will do the same process and save the spreadsheet and then I want to run the append query so that it only pulls new records into my table. I know how to create an append query by clicking Query Design and selecting the table/query I want to use and then selecting The Append Query Type at the top but not sure what to do after that I am still pretty new at the SQL side but I am willing to go that route with help.