Re: Access 97 Database and Postgres

On Wed, 26 Jul 2000, Wilkinson Charlie E wrote:

> Is there a better way? (Even just _slightly_ better?) During our
> migraineXXXXXXXXX migration I will need to transfer the data a few more
> times and I really don't want to make a career out of exporting data...

I've had better success exporting the data out of Access in some sort of
delimited format, creating my own schema in Postgres, then importing the
data in via COPY. Trying to do it with ODBC was just a pain the arse,
slow, and VERY unpredictable.

You could also autmoate this somewhat by writing a Perl script or
something similar and querying the data out of Access (via ODBC, of
course), and then putting it directly into Postgres via DBI. This way you
can massage data in between if necessary.

Brett W. McCoy
http://www.chapelperilous.net/~bmccoy/
-------------------------------------------------------------------------------
"If the code and the comments disagree, then both are probably wrong."
-- Norm Schryer