Hi,
We will be conducting surveys through SurveyMonkey online and will be importing the answers by tab delimited or comma delimited file into access. I was wondering if there is specific way to import delimited files into Access or Is there a specific way I should design the survey online so Access can recognize the file?
Here is my table structure to give you an idea on where I'm coming from. Thank you so much in advance!!!
tblPerson
PersonID (PK)
FirstName (text)
LastName (text)
Company(text)
Department(text )
Date (date/time)
tblPersonAnswer
PersonAnswerID (PK)
PersonID (text)
QuestionID (number)
AnswerChoiceAct ual (number)
AnswerChoiceImp ortance (number)
tblQuestions
QuestionID (PK)
QuestionNumber (text)
QuestionText (text)
2 4764 NeoPa 32,564
Recognized Expert Moderator MVP
For a delimited file you don't need much.
You can probably get away without an Import/Export spec.
It is a good idea to have a table properly predefined to hold the imported data though.
The design should not be affected by the means of transferring the data into the database, just by what you need it to do.
MMcCarthy 14,534
Recognized Expert Moderator MVP
Hi,
We will be conducting surveys through SurveyMonkey online and will be importing the answers by tab delimited or comma delimited file into access. I was wondering if there is specific way to import delimited files into Access or Is there a specific way I should design the survey online so Access can recognize the file?
Here is my table structure to give you an idea on where I'm coming from. Thank you so much in advance!!!
tblPerson
PersonID (PK)
FirstName (text)
LastName (text)
Company(text)
Department(text )
Date (date/time)
tblPersonAnswer
PersonAnswerID (PK)
PersonID (text)
QuestionID (number)
AnswerChoiceAct ual (number)
AnswerChoiceImp ortance (number)
tblQuestions
QuestionID (PK)
QuestionNumber (text)
QuestionText (text)
Use a csv file and import it the first time using the Import wizard.
While the wizard is open click on the advanced button and save the import specificate with a name. e.g. My Import Spec
Create a new table during this import and call it something like tblImportFile
Then for future imports you can use the following code:
DoCmd.TransferT ext acImportDelim, "My Import Spec", "tblImportFile" , "Full path to csv file", True
The True at the end means that the csv file has headings on the first line. Set it to false if it doesn't
Once the file is imported you can create append queries to append your data to the appropriate tables.
Note:
You must delete all records from the tblImportFile table before the next import.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Elmo Watson |
last post by:
I've been asked to develop a semi-automated type situation where we have a
database table (sql server) and periodically, there will be a comma
delimited file from which we need to import the data, replacing the old.
I naurally know that we can use to kill the other data,
but does anyone have any examples of importing a comma delimited file...
|
by: Debbie CD UK |
last post by:
I have a large amount of log files from an electronic contro tester that I
need to import in to an Access database
Unfortunately, they are not comma delimited or fixed with but different
fields are on separte lines
MO NO 123456
serial no xyz
date
Obviously , the Access import wizard can not handle this format.
|
by: D Mat |
last post by:
Hi,
I'm trying to get MS Access 2000 to automatically import a series of
(~200) flat text, tab delimited, data files into a single Access table,
with consistent fields and rows.
The files have different, but somewhat logical naming structures
(ex.Jun01.txt, Jun02.txt, Jul01.txt, etc...).
Is there a relatively simple way to accomplish this,...
|
by: sparks |
last post by:
I have never done this and wanted to ask people who have what is the
best way.
One person said import it to excel, then import it into access table.
but since this will be done a lot, I am trying to avoid this extra
step.
can access read in this file directly into a table as append data?
thank you very much for any pointers
|
by: harry |
last post by:
Hi Folks:
I'm trying to do something that looks simple, but I can't make it
work right.
It's Access 2000 on a Win2000 computer. I create a database with 5
columbs. The data I need to import is text. The way it's formatted
is one line each field, for the 5 fields, then to the next record.
The text file looks like this:
WPTJ410
| |
by: don |
last post by:
I'm trying to import a comma delimited text file into MS Access 2002
version - the first column is set for an auto increment primary key and
everything works right the first time I import a text file, however when I
try to append to this new database table Access always messes up the
import - as long as I ieave the auto increment column out it...
|
by: James |
last post by:
Hi,
I'm importing some csv files with this code
/// start of code snippet
int iPos = strFileName.LastIndexOf(@"\");
string strPath = strFileName.Substring(0,iPos);
string strSelect = "Select * from ";
|
by: Kathie via AccessMonster.com |
last post by:
Hello,
I have to import monthly, files that were once *.csv but due to commas in
addresses, the interface program was changed to dump tab delimited. Now my
code is not finding the files in the folder? The code is below - can anyone
help? (The files still are named with the extension of *.csv)
Function Import_Records()
'On Error GoTo...
|
by: Vik Rubenfeld |
last post by:
Is there a way to import an MS Access database .mdb file into MySQL
running locally on a Mac?
Thanks in advance to all for any info.
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
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...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |