Re: Re: importing into postgres from access

You can in fact access an Access database from Linux.

Just install the Universal ODBC stuff from OpenLink and point it at a
DSN on an NT box. (Don't know about W95/98 but should work.)

You can the use PERL/DBI etc to manipulate the data directly.

If, however, you actually want PostgreSQL to process the Access tables
then forget it.

Cheers,
Stephen.

Yves Dorfsman <x(at)x(dot)com> wrote:
> nsrona <svngo(at)earthlink(dot)net> wrote:
> > I currently have postgres on a Linux 6.2 machine & I can access all of its
> > information from any windows machine using the proper odbc driver.
>
> > Now I want to go in the other direction - Is there a way for my postgres
> > server on the linux box to pull down information from a windows client that
> > is using an Access Database?
>
> I'm relatively new to postgres *and* I'm not sure if I understand your
> question right:
>
> You want "postgres" to connect to another DB server, and populate a
> postgres table from a table in that other DB server ???
>
> If that's the case, I'm pretty sure it's not possible. PostgreSQL is a DB
> server, not a client, and actually I believe this is true for most (all
> ?) DB server: They can act as server and server only, not as client.
>
> Now, one thing you might want to look into, and again assumning I
> understood the question right, is to look at perl and DBI. What this would
> allow you to do is run a perl script on the Linux box that connects to
> both servers (postgres on Linux, and whichever on Windows), and populate
> one table from one with data from a table on the other server. IF you know
> a litle perl, this is trivial to do.
>
>
>
>
> Yves.
> ----
> Yves Dorfsman dorfsmay(at)cuug(dot)ab(dot)ca
> http://www.cuug.ab.ca/~dorfsmay

========================================================================
Stephen Davies Consulting scldad(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133