Importing tables over other tables

[davesmith202]

On database A, I have tables with up-to-date data. On database B, I have tables with old data. I want to get the data from database A into database B, replacing the old data.

What is the best way of doing this?

If I just use, File, Get external data, import, I end up getting tables with different table names. i.e. table Clients1 instead of Clients. Then if I try to delete table Clients, it says I have to delete the relationships first.

But I don't want to have to delete all the relationships.

Please help!

Regards,

Dave

 

[neileg]

I think you need to delete the data from your tables, not the tables themselves. Then when you import the new data, instead of creating a new table, you append the data to the old one. The relationships will be retained even if the tables are empty of data, so long as the tables are still there.

 

[IgorB]

All you have to do is:

1) Link Table from db B to database A using File->Get External File->Link only very first time.
2) Delete all record from linked table.
3) Append all records from table in db A to link Table.