Using Access to analyze and report SurveyMonkey results?

[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/_exportE...s/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!

[timmg]

Re: Using Access to analyze and report SurveyMonkey results?

Depending on what you're trying to accomplish you may want to export
as Excel, which is technically unnormalized, but a whole lot easier to
understand. Over the years I've made that my default preference with
SurveyMonkey (which I like a lot)

good luck

Tim Mills-Groninger

On Jun 24, 11:02 am, J <mjan...@crww.c omwrote:

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/_exportE...s/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!