By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,966 Members | 1,145 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,966 IT Pros & Developers. It's quick & easy.

Importing table to replace existing table

P: n/a
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

Nov 14 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ted
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

Nov 14 '05 #2

P: n/a
Thanks, that works.

Nov 14 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.