Re: Transfer Access Database tables to ISERIES

Hello Mike, 

A couple of options:

1.) Write a VB routine in MS Access to read the access table and insert to 
an iSeries table with ODBC.

2.) If you're open to commercial options, check out our RPG2SQL Integrator 
product.  RPG2SQL can be used to write an RPG program that reads and 
writes to MS Access or any other PC database such as SQL Server. 

For more info check out or web site or feel free to contact me directly. 

Regards,
Richard Schoen
RJS Software Systems Inc. 
"Providing Your....iNFORMATION NOW!"
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT
------------------------------

message: 8
date: Thu, 7 Sep 2006 15:09:59 -0400
from: "Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>
subject: Transfer Access Database tables to ISERIES

I need to transfer several tables from an Access Database- I know, I
know.  Theres not any chance any time soon of the Access being replaced
as it is from a vendor product. 

Anyway this has to be an automated process on a quarterly
basis(preferably kicked off from the ISERIES. 

I don't see a way to do this with Client Access. 

Any ideas on how to accomplish this? 

Michael Smith
iSeries.mySeries.