When you data from Access to Excel a copy of the data is created in Excel?
You can copy data from Access and paste it directly into Excel.
From a table or query, data can be selected and then copied and
pasted into Excel. In that case, data changing in the original
Access file will not change data in the Excel file. To do that
there must be a link between the data. You can also import data
from Access into Excel and from Excel into Access, again
maintaining a link to the source if you want.