RE: Suck data from MS Access to AS400

[Mike Cunningham <mcunning@xxxxxxx>]

I have never used this but it looks like it might work to give JDBC access to any ODBC accessible database http://www.herongyang.com/jdbc/JDBC-ODBC-MS-Access.html 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Friday, November 21, 2008 10:12 AM
To: Midrange Systems Technical Discussion
Subject: Re: Suck data from MS Access to AS400

Only if MS provides a type 4 JDBC driver for Access, which I don't believe
they do since Access is not a true RDBMS.

I supose if you have an SQL server or DB2 server or otherwise, you could use
a type 4 JDBC driver to one of those that passed through to the Access DB.

There our some other products, both IBM and third party, that act as a
gateway, using ODBC to access the PC based DBs, from the iSeries.

Charles

On Fri, Nov 21, 2008 at 9:19 AM, Tomasz Skorża <t.skorza@xxxxxxxxxxx> wrote:

> Hi guys
>
> Dou you know if it is possible to directly sucking data from MS Access
> database to AS400 DB2
> database (by process/program calling and running on AS400 - not on Windows
> station)?
>
> --
> Regards
>
> Tomek
>
> ---------------------
> Please consider the environment before printing this email.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.