I tried, but I can�t.
I just installed MDAC from Microsoft, but I can�t connect MS-ACCESS. When I clicked in button Connect,
nothing to do, only my screen blink. This screenshort show me:
DataSource: I put my OBDC Connection
Below, show me: driver, driver version, user, server name (ACCESS), etc.
Please, Could you help me, please?
Thanks and Regards.
Topo_Gigio
------- Original message -------�
From: Christof Glaser <gcg@gl.aser.de>�
Date: Thu, 8 Apr 2004 10:20:56 +0200�
Subject: Re: [CYGWIN] MS-Access in PostgreSQL ... I can �t....�
Hello,
Am 08.04.2004 um 03:45 schrieb Topo Gigio:
> Hello,
> I need to connect MS-ACCESS inside my PGADMIN (Postgresql). I
> used 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Lycos Email has 10 MB of FREE storage space. http://mail.lycos.co.uk