Prev: SQL In Statement with Variables?
Next: Export to Text File with newline delimiter
From: J on 24 Jun 2008 12:02
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!
From: timmg on 25 Jun 2008 12:26
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...(a)crww.com> wrote:
> 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!

 | 
Pages: 1
Prev: SQL In Statement with Variables?
Next: Export to Text File with newline delimiter