J
J
I recently used SurveyMonkey to host an online survey and one of the
options they offer is to download the data for a relational database.
When you download the file, (you can download a sample here:
http://www.surveymonkey.com/_exportExamples/Examples.zip) , you end up
with a folder with three html files: QuestionTable, ResponseTable, and
TableOverview. You also end up with two subfolders: Excel and CSV.
I've imported the excel files as tables into Access and setup
relationships based on the foreign keys and unique IDs as its laid out
in the Table Overview file, however I'm having trouble making heads
and tails of the information found n the QuestionTable and
ResponseTable files and how to incorporate that into the relationships
of the database.
Any help you can provide would be greatly appreciated!
Thank you!
options they offer is to download the data for a relational database.
When you download the file, (you can download a sample here:
http://www.surveymonkey.com/_exportExamples/Examples.zip) , you end up
with a folder with three html files: QuestionTable, ResponseTable, and
TableOverview. You also end up with two subfolders: Excel and CSV.
I've imported the excel files as tables into Access and setup
relationships based on the foreign keys and unique IDs as its laid out
in the Table Overview file, however I'm having trouble making heads
and tails of the information found n the QuestionTable and
ResponseTable files and how to incorporate that into the relationships
of the database.
Any help you can provide would be greatly appreciated!
Thank you!