[KLUG Members] Postgres to MS Access conversion

[Mark Szidik/mlc]

|---------+-------------------------------->
|         |           Adam Bultman         |
|         |           <adamb@glaven.org>   |
|         |           Sent by:             |
|         |           members-admin@kalamaz|
|         |           oolinux.org          |
|         |                                |
|         |                                |
|         |           12/11/02 10:04 AM    |
|         |           Please respond to    |
|         |           members              |
|         |                                |
|---------+-------------------------------->
  >----------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                      |
  |       To:       members@kalamazoolinux.org                                                                           |
  |       cc:                                                                                                            |
  |       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...


I have used the Postgres ODBC driver to connect directly to Postgres and
then used MS Access's Import feature to pull the data directly into new
Access tables.  Piece of cake.  I have not done BLOB's, however.


-Mark Szidik