Populate a table from and linked table

I have an access database that links to a ProvideX database.

TableA is the linked table.
TableB is my table in access.

I want to read the data in TableA and add records to TableB that do not exist in TableA. But I would like this to happen automatically. Not necessarily by clicking a button.

Any suggestion or help to proceed would be greatly appreciated.