Q: how do I go about keeping the Access table from automatically updating when I add information to the Excel worksheet?
(1)Remove the link from the Excel Worksheet. If Necessary create a local table in Access to hold the Excel Data. (2)Create an Import process to import the Excel Data into the Access Table, can use VB for the Import.
For more control use an update query to update an Access Table with the Excel Data vs. replacing the entire table.
Use a button, menu item, or the app/form 'Open' event with a decision msgbox to ask user if OK to update the Excel Data.
option Leave the linked Excel Table and run an update from the linked table to a new static table in access.