Match a table from MS ACCESS and MS SQL

See more:

SQL

MS-Access

table

Hello guys,

I want to put a button in an existing MS ACCESS file and when a user clicks on it i want to check a column record and match it with a same column in Ms SQL table.
If some records are missing in MS SQL i want to insert those into SQL.

For example:

I have a table in MS-ACCESS AccessTable and a column with CommonID.
And a table in MS SQL with name SQLTABLE and a column with CommonID.
I want to run a match on both columns and if any entry is missing in MS SQL after the match i want to insert it into MS SQL table.

Would be thankful if you can guide me how can i achieve it

What I have tried:

Searched google but haven't find what i was looking for