MS-Access Data to DB Tables?

Hi Gil,

The Script Center lets you schedule commands to run. That could include
Import to load text files into DB2 database. It could also call a
program to extract your Access data.
You will need either to write a program to extract your data (and maybe
call it from the script center), or locate a data porting tool. The
makers of Chyfo will probably recommend that. IBM let you download
Scriptoria from their web site which will actually help you set up DB2
tables for access from MS Access.

Depending what you're really trying to achieve, you could also look at
on-demand replication between DB2 and Jet. See the Replication Guide in
DB2 online documentation...

--Greg

Gil wrote:

> Hi DB2ers,
> Is it possible to do the following using the Script Center?
> If so, how?
>
> 1. Connect to MS Access via an ODBC connection.
> 2. Do queries.
> 3. Send the result set data back to DB2 to update data.
> I am basically trying to use certain fields of table A and B to
> populate table C of corresponding fields.