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! 1  7172 
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!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Mark |
last post by:
I am producing a report that requires me, among many other things, to
calculate the average contracts for about 1000 companies during the yr
2003. The "quirk" is that all the companies do not have the same
number of months. When using DB2 the below code counts the average
contracts of each group for 2003. What code can I use in MS ACCESS to
produce the same result?
SELECT
COMPANY_NAME,
|
by: CSDunn |
last post by:
Hello,
I have a situation with MS Access 2000 in which I need to display report
data in spreadsheet orientation (much like a datasheet view for a form). If
you think of the report in terms of what a spreadsheet might show, the
column names will actually be dynamic, based on data from a SQL Server 2000
database. The row data will also come from the same database. So in this
case, I will have a main report and a subreport. I've already tried...
|
by: John Beeler |
last post by:
I am a graduate student writing a thesis on a space in Indianapolis
called the Circle.
I'm trying to figure something out that would really help me out as I
write this thing.
I would like to be able to enter in a structure, the range of dates it
existed, and the lot number (there are 19 lots around the Circle, but
I'm planning on technically counting the center Circle itself as a lot
- so 20). I would enter something like:
|
by: Klint Gore |
last post by:
query is
select t2.field4, t1.*
from t1
left outer join t2 on t2.field1 = t1.field1 and t2.field2 = t1.field2
There are 55k rows in t1 (103 fields) and 10k in t2 (4 fields, 4 is text).
before vacuum analyze the query gave 10k rows like it was doing an inner
join. after vacuum analyze gave the full 55k.
|
by: agus liem |
last post by:
Hai..
I introduce myself, my name : Agus, from Indonesia.
Im develop application using POwerbuilder 7 and postgresql 7.3.
I have serveral error, and cannot solve yet. Anybody help me?
This is the error :
1. When I connecct postgresql using powerbuilder , there is message like
this ...
Catalog tables could not be created and are not available for use
| | |
by: Jerome Ranch |
last post by:
Okay
So I've got pivot tables setup in Access 2003.
Only about 30K records in the current 2005 databases...the pivots
summarize the info in a number of nice ways.
I need to get the pivot tables into a document so I can distribute the
tables, as is, as an electronic report (without the detailed data)
So I export to rtf and xls, and I get an error that there is a too
much information. I don't want all the data, just the summary table!
|
by: Robert |
last post by:
How do you get an accurate count of the number of records returned from
a query when using linked tables.
I have an access 2003 database as a front end to another access 2003
database that contains only tables. I have linked the tables for the
front end to the back end database.
I am trying to set the recordsource of a form to a query established by
the user to narrow the scope but I don't want to display the form if
there are no...
|
by: somanyusernamesaretakenal |
last post by:
What I am trying to achieve:
Basically I have generated a report in access. This report needs to be updated using excel. (Updating the new data, not changing existing data)
What I did was I imported the existing report into Excel (Tools – Office Links – Analyze It with MS Excel). Then I linked the report to the Excel file. (File – Get External Data – Link tables) and a link table was automatically generated.
I wanted to test the link,...
|
by: Clearview |
last post by:
This is my first post to the forum and hoping I can get help as I have spent a way too much time on this problem, and thinking it is probably something really simple to resolve.
I am using Access 2000 and trying to create a Query which draws its parameters from a Report Criteria Selection Form, which will define the data source for a report.
On a Report Selection Form if user enters a part# containing "PP"
then criteria will be for the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
