Selecting From Surveys in SurveyMonkey
The driver offers the possibility to select surveys as relational tables.
You can create your own Surveys by performing the following steps:
- In SurveyMonkey, go to the home page and click "Create Survey" on the vertical navigation bar.
- Either start a new survey from scratch or pick one of the many templates SurveyMonkey offers.
- Design and create new questions for your survey.
- When finished, pick one of the options to share your survey and start receiving data from it.
Selecting Responses from Your Survey
To access the responses to your surveys, append _Responses to your table name, MySurvey_Responses in the query below.
SELECT RespondentId, QuestionText, ChoiceId, ChoiceText, ChoiceWeight FROM MySurvey_Responses
Selecting Questions from Your Survey
To access your survey questions, append _Questions to your table name, MySurvey_Questions in the query below.
SELECT QuestionId, QuestionFamily, QuestionSubtype, QuestionText, AnswerText FROM MySurvey_Questions