[postgis-users] OT: moving my access data into postgis

[Norman Vine]

Tyler Mitchell writes:
>
>Slightly off topic, but relevant nonetheless.
>I've got a ton of data in an MS Access database and I've been using the
>postgresql odbc driver to export the data into a postgis database.  But
>man, it's really, really slow.   You thought gist indexing of large tables
>was slow!  Well, I'm looking at 1-2 hours for half a million records with
>only 4 integer columns.
>
>Can you suggest a better method of moving out of Access?

FWIW I haven't tried this
http://pgadmin.postgresql.org/pgadmin2.php?ContentID=15

Norman