How do I import mass data into an Access table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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


Jesper
 
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:D[email protected]...
 
Access can import text file data. What happens when you try?

--
Regards

Jeff Boyce
<Office/Access MVP>

"Working Hard or Hardly Working?"
 
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?"
 
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.
 
Back
Top