How do I import mass data into an Access table?

[Working Hard or Hardly Working?]

I am currently trying to import a mass data file into a single table. I do
not wish to spend hours typing it all out, as I have a deadline for this
project. How can I do it without having to keep looking at the data, and just
put it all in straight away?
Many thanks to those who help.

 

[Jesper F]

I am currently trying to import a mass data file into a single table. I do

not wish to spend hours typing it all out, as I have a deadline for this
project. How can I do it without having to keep looking at the data, and
just
put it all in straight away?
Many thanks to those who help.

If you know the structure of your data you can automate the import.
Is that what you're after?


Jesper

 

[Jeff Boyce]

What form/format is the mass data file? Access can import a wide variety of
formats.

Even if your mass data is not well-normalized (and your Access database is),
you can import the raw data (temporary), then use append queries to parse
the pieces and insert them into your (permanent) table structure.

--
Regards

Jeff Boyce
<Office/Access MVP>

"Working Hard or Hardly Working?" <Working Hard or Hardly
[email protected]> wrote in message
news[email protected]...

 

[Working Hard or Hardly Working?]

The data is stored as a text file. Here is the link to it:
http://www1.edexcel.org.uk/dida-d201/documents/links/youthorg.txt Thanks.

 

[Working Hard or Hardly Working?]

See my previous reply, but the information is stored as a text file.
http://www1.edexcel.org.uk/dida-d201/documents/links/youthorg.txt

 

[Jeff Boyce]

Access can import text file data. What happens when you try?

--
Regards

Jeff Boyce
<Office/Access MVP>

"Working Hard or Hardly Working?"

 

[Working Hard or Hardly Working?]

That's just it, I don't know how to! It's pretty complex!

 

[Jeff Boyce]

Working through, step by step, how to do an import may be beyond the time I
have to provide support. Perhaps another 'group reader can walk through it.

A generic outline of what you need to do is:

* open an Access database
* select File | Get External Data | Import...
* navigate to the text file you want to import
* follow the steps the import wizard offers.

If you need more information, consider checking Access HELP for "import".

--
Regards

Jeff Boyce
<Office/Access MVP>

"Working Hard or Hardly Working?"

 

[Brendan Reynolds]

Just one thing to add - in the "Import" dialog box, in the "Files of type"
list, select "Text Files (*.txt;*.csv;*.tab;*.asc)".

The file appears to be a standard CSV file, so should import using the
default settings in the import wizard after that.

 

[Working Hard or Hardly Working?]

Thanks everyone, much appreciated. Have a nice day.