Script for importing tables and building relationships

[poet1234]

I am building a database where the data comes monthly on a CD from an external source, already in Access. There are three tables, two of which are related to the "main" table. When the data comes, the primary key field on the main table is not defined as the primary key, so I have to manually do that, then I manually build the one-to-many relationships. Because I will be handing this off to a user who is no a relational database person, I would like to create a script or some sort of automated way to import these tables and build the relationships. Is there a way to do this in VBA? If so, could someone point me in the right direction? Thanks much.