using one database to update another

M

mr relaxo

Well-known member
Joined
Jun 25, 2003
Messages
53
Location
Auckland
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.
 
Last edited by a moderator:
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.
 
Back
Top