I created a macro in Access 2002 that imports a specific table from one access database to another. The table in question is in a relationship with another table on the second database. The name of the tables are the same in both databases. When importing into the second database, the table is renamed i.e Table1. I cannot delete the second table before importing because of the relationship. How can I import the table , using the same name and maintain the integrity of the database without deleteing the relationship?
