About MS Access -> Postgresql and ODBC (Another answer)

[Administrador <ag...@ho...>]

Also, if anybody has interest about the "Upsizing Toolkit": You can =
visit:

http://dspace.dial.pipex.com/boylesa/


Antonio Gallardo.



> -----Mensaje original-----
> De:	Oscar Buijten [SMTP:os...@el...]
> Enviado el:	jueves 21 de junio de 2001 1:28
> Para:	sql...@li...
> Asunto:	Re: Postgresql and ODBC > MsAccess (The answer)
>=20
> For those who are interested:
>=20
> If you would like to access your Postgresql server on your linux (or
> whatever else box) from MickeySoft Access you will need to install =
the
> Postgresql ODBC server. It is a piece of cake to do. Just ftp to (be
> carefull, it might be bussy on this site)
>=20
> ftp.postgresql.org=20
>=20
> and move to pub/
> Download the .html and .txt files there for your reference.
>=20
> Then move to full/
>=20
> and download: psqlodbc-07_01_0005.zip
>=20
> unzip, doubleclick and off you go.
>=20
> To access your Pg Dbase from MsAccess97:
>=20
> Open a new database, in tables click on new.
> Select: attach table and click OK.
> A new window will open. Fromfile type, select: ODBC
> A new window will open.
> Next to the DSN name field you click on NEW.
> A new window will open. Select PostgreSQL, click next
> Now fill in the name of the new DSN entry you are about to make.
> The name of the Dbase you are going to access on Postgrqsql will do =
in
> most cases.
> Click on next and then on finish.
> A new window will open.
> This one looks very simalar to the user id in SQL ledger doesn't it?
> Fill in the details (you may want to peek into the advanced settings =
while
> you'r there) and off you go!
>=20
> Enjoy,
>=20
> Oscar
>=20
>=20
> ----- Message d'origine -----=20
>   De : Oscar Buijten=20
>   =C0 : sql...@li...=20
>   Envoy=E9 : mercredi 20 juin 2001 12:08
>   Objet : Postgresql and ODBC > MsAccess
>=20
>=20
>   Hello all,
>=20
>   Realising that thismay not be the perfect place to ask my question =
I
> want to give it a try anyway.
>   I currently have information stored in a Access97 database.
>   Part of this information I would need to transfer to Postgresql (on =
a
> linux box (Mandrake 8.0) to use it in the SQL-ledger.
>=20
>   Question is: how to do this?
>=20
>   I assume I would need to do it using ODBC, but I have no clue what =
to
> install (as a driver) and
>   where to install it (on the linux box or on the wondoze box).
>=20
>   Does anyone has a good answer on this?
>=20
>   Thanks in advance!
>=20
>   Regards,
>=20
>   Oscar
>   =
________________________________________________________________________=

>=20
>   Oscar Buijten
>=20
>   Tel:     +33.4.67.57.97.45
>   Fax:    +33.4.67.57.97.46
>   GSM: +33.6.20.84.15.22
>   Email: os...@el...
>=20
>   http://www.elbie.com <<Archivo: ATT00001.htm>>=20