using one database to update another

[mr relaxo]

Hey I was wondering if it was possible to use a table from one database eg. access - read a column such as "no_in_stock" and then use the values in that column to update a "no_in_stock" column in another database table eg. mysql.

 

If anyone has some experience with this type of operation Id love to hear how you went about it or even if its possible.

 

Thanks.

Edited August 2, 2003 by Robby

[Robby]

Create 2 seperate connection objects, one for each provider.

Read the no_in_stock into a variable from Access then update the appropriate column in mySql.