Skip site navigation (1) Skip section navigation (2)

Re: MS-Access in PostgreSQL ... I can´t....

From: Christof Glaser <gcg(at)gl(dot)aser(dot)de>
To: "Topo Gigio " <topo_gigio_agudos(at)lycos(dot)co(dot)uk>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: MS-Access in PostgreSQL ... I can´t....
Date: 2004-04-08 08:20:56
Message-ID: A8FDEC5E-8935-11D8-97C7-000A957E650E@gl.aser.de (view raw or flat)
Thread:
Lists: pgsql-cygwin
Hello,

Am 08.04.2004 um 03:45 schrieb Topo Gigio:

> Hello,
>          I need to connect MS-ACCESS inside my PGADMIN (Postgresql). I 
> used <plugins> <Connection Debbuging
> Tools>, selected database (directly or by ODBC), clicked button 
> connect, but doesn´t appear nothing, nothing
> to do.
>
>          For example: I´ll read tables from MS-ACCESS, filter some 
> fields(data) which need, load on PostgreSQL.
> Important, I need read the data from database MS-ACCESS, not only 
> structure. Anyway, Select and Insert? I
> can?

You can connect to Postgres database tables from within Access (linked 
ODBC tables).
Then you can do "Queries" in Access and select/copy the data as you 
like.

I think you cannot connect to an Access database (or any other database 
except Postgres) from
PG-Admin, since that is designed specifically for Postgres.

Best regards,

Christof Glaser
-- 
--      gl.aser   .   software engineering  .   internet service
-- Doelitzer Strasse 37  .  D-04277 Leipzig   .   fon +49-341-303 20 51
-- http://gl.aser.de/ .  sms +49-177-779 28 43 . fax +49-0341-303 20 52


In response to

pgsql-cygwin by date

Next:From: Topo Gigio Date: 2004-04-09 00:35:27
Subject: Re: Re: MS-Access in PostgreSQL ... I can ´t....
Previous:From: Topo Gigio Date: 2004-04-08 01:45:17
Subject: MS-Access in PostgreSQL ... I can´t....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group