Struggling a bit with getting some vba to update an access table.
I keep getting close but not close enough based on code designed to add records or and doing it in an inefficient way so probably better to get fresh advice.
the scenario is that I have an access table with some entries and a excel spread sheet with some entries. and I want to update the lines on the spread sheet to the data base if the ID exists or add them to a new line if they do not exist (leaving any other lines in the data base unchanged).
If I have a template (or even general instructions) for doing this I can probably work it out.
Bookmarks