Importing table to replace existing table

[francophone77]

There is a table on a server from which I copied into my local
database. I don't want to update this table locally, I want it to be
controlled by the table that is on the server on a different database.
Linking is not an option as it is 2000 miles away and the connection is
not very fast. I would prefer to copy that table weekly into my local
database. Note these databases serve different functions.

Is there a way I can easily replace the old table with the updated
table without messing up the structure of my database (ie.
relationships).

TIA

[Ted]

Re: Importing table to replace existing table

Tia:
I would play it safe and add an extra step. First I would append the
existing data from the table into another table (so that I could
retrieve it if I needed to).
Then I would run a delete query to remove all of the records in the
table and then import the new data into the table.
One thing I would add while appending the old data to the other table
is to add a date field of when the data was appended. This would help
me to retrieve the records appended on a particular data and to help
remove records that have reached a certain age, such as six to twelve
months old.
I hope that helps.
Ted

[francophone77]

Re: Importing table to replace existing table

Thanks, that works.