RE: Accessing MS Access from Java on iSeries

Just brainstorming here...

Have you considered commercial products? iWay, for example, has an adapter to 
MS Access, which supposedly can be accessed by JDBC:

http://www.iwaysoftware.com/products/adapters/msaccess.html

I've never used it, and you might find a similar product better suited for your 
purposes. 

Also, doesn't the new version of MS Access have XML import capabilities? You 
could potentially put your iSeries records into XML format to be imported into 
MS Access. Again, something I've never tried, just trying to brainstorm 
options. 

Kelly




-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Holden Tommy
Sent: Tuesday, January 31, 2006 10:59 AM
To: Java Programming on and around the iSeries / AS400
Subject: RE: Accessing MS Access from Java on iSeries


In MS Access with the Client Access ODBC you can create a "link table"
directly to the data on the iSeries.  Might be worth looking into in
this scenario. 


Thanks,
Tommy Holden


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Price, Chris
Sent: Tuesday, January 31, 2006 10:46 AM
To: Java Programming on and around the iSeries / AS400
Subject: RE: Accessing MS Access from Java on iSeries

When you say feed data, do you mean on a record by record basis, or
complete
files?

If it's complete files, then I would guess that the easiest way would be
to
convert the data into a .csv file using CPYTOIMPF, and then importing
the
data in Access (I don't know Access, but I assume that such an action
could
be scripted for automation).

If you need to do it on a record by record or transactional basis, I
would
ask whether Access is the right tool for the job - it simply isn't a
transactional distributed database

Regards,
Chris.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Anand, Rajesh
Sent: 31 January 2006 10:44
To: java400-l@xxxxxxxxxxxx
Subject: Accessing MS Access from Java on iSeries

Folks,

        Have been through the archives but have not found anything
conclusive.

        Does anyone have any idea how this can accomplished??

        This is an old age problem where we need to feed data to MS
Access and we need to provide an automated solution from iSeries.

        I know its has been debated in the past but want to know is, if
there are any MS jar files available to use on iSeries using Java.

        Thanks for your help in advance.

        

Rajesh Anand
Email:Rajesh_anand@xxxxxx
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy,
retain
or redistribute it. Click here for important additional terms relating
to
this e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------