importing tables

[Emma]

I know this is a really silly question but before I split and make mde. I've
been importing the tables from the current database to the newer version
(since the newer version has new tables). But this leaves me with several
tables named with a 1 on the end ie table1. I then have to go through the
tables and delete the original by renaming the tables. Since I don't want to
loose the relationships. Does this make sense or is there an easier way?

 

[Arvin Meyer MVP]

If you had split first, it would be easier to add any new tables to the
existing database. The relationships remain in place for the existing
tables. If the tables are identical, you will probably need to append data
before deleting them.