Populate a table from and linked table

By sspencer ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums