Survey Database Creation and Import from Excel Question
I've run into a problem with a database I just created. I need to compare pre- and post-tests, which were inputted into Excel.
Tables: Subjects, Answers, Questions
Relationships: Subjects <--ID#--> Answers, Answers <--QuestionID #--> Questions
The problem that I ran into is that by using this format, each Question made it it's own record, not a field like in a previous database I created. Now, I can't import the questions from excel. In other words, there are no fields to import Question 1 through Question X into. Does anyone have any suggestions?