I am currently working on a project for my MSc and need to figure out a way to take an Access database that consists of one table and transfer that data to another Access database consisting of many relational tables.

Does anyone have any suggestions on how to go about doing this? There are approximately 6,000 records in the original database.