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 <[EMAIL PROTECTED]>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>
************
