From: | Wilkinson Charlie E <Charlie(dot)E(dot)Wilkinson(at)irs(dot)gov> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Access 97 Database and Postgres |
Date: | 2000-07-26 13:54:57 |
Message-ID: | C9077ABBC4CED311A69F0004AC3699EB02FBF573@nct0010mb03.nc.no.irs.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I need to get data out of an Access database and into a *real* database,
i.e., Postgres. I've done the ODBC thing. It was painful to set up
(did you know MS has _bugs_ in their ODBC support?? *gasp!*) and even
more painful exporting the data into Postgres. Some tables failed to
export, plus I ended up having to do a pg_dump, massage the schema *and*
the data and reload it all anyway.
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...
Thanks for any help.
-cw-
--
Charlie Wilkinson - TRIS Development Systems Administrator
IS:SD:CT:CC:TD
Phone: 202-283-3241
MSMail: Charlie E Wilkinson
SMTP: cwilkins(at)tris(dot)irs(dot)gov
Home: cwilkins(at)boinklabs(dot)com
This message constructed from 90% post-consumer electrons.
From | Date | Subject | |
---|---|---|---|
Next Message | Jeffery Collins | 2000-07-26 13:58:27 | Re: Some questions on user defined types and functions. |
Previous Message | Wilkinson Charlie E | 2000-07-26 13:12:37 | RE: Describe structure. |