[KLUG Members] Postgres to MS Access conversion

[Buist Justin]

Seems like a pretty simple task ... unlike the MS tools your open source alternatives tend to be easy to migrate -off- of.  The pg_dump tool will let you dump your entire DB, including the CREATE TABLE commands to a flat text file which Access should import after a bit of tweaking.  Something like:

pg_dump --inserts your_db > flatfile.sql

If you have a HUGE number of tables you'd probably want to come up with a macro to change common things -- like auto-incrementing sequences to an identity column (or whatever Access calls it) and such.

The actual insert statements though should work w/out a problem, unless perhaps you have BLOBs or something in there.  Never dealt with that under either PGSQL or Access.

Justin Buist


> -----Original Message-----
> From: Adam Bultman [mailto:adamb@glaven.org]
> Sent: Wednesday, December 11, 2002 10:04 AM
> To: members@kalamazoolinux.org
> Subject: [KLUG Members] Postgres to MS Access conversion
> 
> 
> 
> Does anyone here know of a decent, preferably cheap program 
> to export the
> data from a postgres database to an MS Access db? I've been 
> googling, and
> it's nice to see there are a lot of Access to postgres tools, but I'm
> seeing only one program to convert pg to access...  I only need this
> program once, so it seems dumb to have to pay for it...
> 
> 
> 
> -- 
> adamb@glaven.org
> [ www.glaven.org ]
> 
> _______________________________________________
> Members mailing list
> Members@kalamazoolinux.org
> 
>