Re: Transfer Access Database tables to ISERIES

On 9/7/06, Smith, Mike <Mike_Smith@xxxxxxxxxxxxxxxx> wrote:

>
> 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.
>

http://www.ihocquery.com could do this for you.  It wouldn;t be completely
automated, but at once a quarter I don;t think it would be such a burden.
Basically, it would go like this:

1) Run a select statement from the Access database.
2) Export the grid to a Dump File, targetting iDB2.
3) Connect to the iSeries. Open the dump file and press F5.

You would need to do this for each table you want to move.  It's not the
fastest in the world, but it comes in handy for moving data from other
platforms to the iSeries.