AnsweredAssumed Answered

Survey Database Creation and Import from Excel Question

Question asked by BG_1 on Jan 12, 2011
Latest reply on Jan 25, 2011 by philmodjunk

Title

Survey Database Creation and Import from Excel Question

Post

Hello all,

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?

Outcomes