title: MS Access event-driven Data Macro to update table (example)
body: <p>I have imported some data into Access from Excel. Now I want to write a code similar to trigger which will update another table whenever I get new data from Excel.</p>
  
  <p>I know I cannot write a trigger in Access, so I am trying to use a Data Macro. Can anyone provide me help in how to do this using a data macro?</p>