Append new data from an Access Query to a table

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.

Once you create the append query,you run it.
After the import, & reconcile , run the append query in the macro.

okay you lost me. I get that I run the append query in the beginning and that will get the data to the table but when you say "run the append query in the macro" that's the piece that's not clear. What macro? When I run the append query currently it just appends all the data into the table meaning when I run it a second time it repeats that step. My issue is I can't have duplicate records come into the table and none of the fields by themselves are unique so when I run that append query I need it to look at each record and if it is a duplicate I don't want to be brought into my table.