Обсуждение: MS-Access in PostgreSQL ... I can´t....

Поиск
Список
Период
Сортировка

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

От
"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?


Table One  (Access)                                                     table two (Access)
(id_one, name, address, xxx, zzz)                   (id_two, description, number, xxx,zzz)
                        \                                                                       /
                         \                                                                     /
PostgreSQL
(table One)                                                                    (table two)
(id_one, name)                                                              (id_two, description)

If this design impossible. What do I do? Could you help me, please.
Thanks and Regards...

Topo_Gigio_Agudos.

Lycos Email has 10 MB of FREE storage space. http://mail.lycos.co.uk

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

От
Christof Glaser
Дата:
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