Greetings,
At work I have inherited a database from a predecessor that is incredibly inefficient. In essence, it contains case information and subject information where there can be multiple subjects to one case. For example this is how it is entered:
Date Location Subject Name
1/1/2000 123 Main St 1. John Smith 2. Jane Doe
Subject DOB Gender
1. 1/1/1980 2. 1/1/1985 1. Male 2. Female
I already have the tables created in the new database with the proper ID fields and relationships defined. However, I am unsure if there is a way to easily import the old data. For instance, using the above example, I would need John Smith and Jane Doe to be classified under CaseID 1 but SubjectID 1 and 2, respectively.
At work I have inherited a database from a predecessor that is incredibly inefficient. In essence, it contains case information and subject information where there can be multiple subjects to one case. For example this is how it is entered:
Date Location Subject Name
1/1/2000 123 Main St 1. John Smith 2. Jane Doe
Subject DOB Gender
1. 1/1/1980 2. 1/1/1985 1. Male 2. Female
I already have the tables created in the new database with the proper ID fields and relationships defined. However, I am unsure if there is a way to easily import the old data. For instance, using the above example, I would need John Smith and Jane Doe to be classified under CaseID 1 but SubjectID 1 and 2, respectively.
Last edited: