By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,795 Members | 1,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,795 IT Pros & Developers. It's quick & easy.

Using Access to analyze and report SurveyMonkey results?

P: n/a
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!
Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.comwrote:
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!
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.