D
Darren
Hi,
I am trying to import Excel CSV files for a survey database.
The Excel files look like this:
Date Location surveytype Q1 ..... Q60(these are the column headings)
my trouble is I want to import them into a table that looks like this:
tblsurvey
surveyresponse_ID
Question_ID
Response_txt (question answers - multiple choice)
Using this table structure will allow for any number of survey questions as
question_ID is linked to another table with the actual survey questions.
My trouble is that the number of questions for each survey are not always
equal - so I can't do a straight simple import for every survey. Some
survey's have 30 questions some have more, plus some have subquestions like
3a, 3b, 3c.
Does anyone have any suggestions on how to make this import go smoothly?
This is what I have thought of doing. When the user inputs the new survey
questions into a form - create a temp table with column headings based on
what is typed in the form. I.e Q1, Q2, Q3, Q4a, Q4b. Then during the import
have the user select from a list box which survey it is, which will pull the
appropriate temp table to dump the data in before appending it to the master
tblsurvey. I am thinking this is not the easiest way - so I am open to
suggestions.
Thanks for your time,
Darren
I am trying to import Excel CSV files for a survey database.
The Excel files look like this:
Date Location surveytype Q1 ..... Q60(these are the column headings)
my trouble is I want to import them into a table that looks like this:
tblsurvey
surveyresponse_ID
Question_ID
Response_txt (question answers - multiple choice)
Using this table structure will allow for any number of survey questions as
question_ID is linked to another table with the actual survey questions.
My trouble is that the number of questions for each survey are not always
equal - so I can't do a straight simple import for every survey. Some
survey's have 30 questions some have more, plus some have subquestions like
3a, 3b, 3c.
Does anyone have any suggestions on how to make this import go smoothly?
This is what I have thought of doing. When the user inputs the new survey
questions into a form - create a temp table with column headings based on
what is typed in the form. I.e Q1, Q2, Q3, Q4a, Q4b. Then during the import
have the user select from a list box which survey it is, which will pull the
appropriate temp table to dump the data in before appending it to the master
tblsurvey. I am thinking this is not the easiest way - so I am open to
suggestions.
Thanks for your time,
Darren