external table refresh

[mike g]

sorry if this the wrong group, i didnt see a tables group.
curious-
when i create a table using the external odbc tool, i have the option of
creating it as a link to the external data, or to fully import the external
data.
when does the data get refreshed??
or, does it always stay the same from the day it was created?

 

[Douglas J. Steele]

If you import the data, then you've made a copy of it inside the Access
database. That copy will never be updated based on changes to the original
external table.

If you link, what you see in Access is actually coming from the external
table, so it'll always be in synch.