RE: Suck data from MS Access to AS400

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.