Thread: How to import data from MDB or pipe delimited file into PostgreSQL

What is the best way to import into a PostgreSQL database data from a
Microsoft Access database?

Should I export the data to a pipe or comma delimited file and then import?
*But how can I do that* ?

With mSQL it is easy, it has already a builtin function where you specify
the name of the text file you are importing, the database and table to input
the data, which character should be treated as a separator (comma, pipe,
etc.).

TIA,
Paulo

Not long ago, PostgreSQL proclaimed...
> What is the best way to import into a PostgreSQL database data from a
> Microsoft Access database?
>
> Should I export the data to a pipe or comma delimited file and then import?
> *But how can I do that* ?

Once you have an Access table exported using some kind of delimiter, use
the COPY command to import it into a table in PostgreSQL.

psql> COPY INTO TABLE1 FROM '/home/joe/access_export.csv' USING
      USING DELIMITER ',';

I'm not aware of any way to import table schemas from Access- you'll
probably still have to do that by hand.

-=Fozz

--
Doran L. Barton <fozz@iodynamics.com>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>