[Eikinskjaldi]

Originally Posted by Toupsx

It really doesn't seem that hard of a thing.. you have 1 database with 2 columns with data in them.. you have another database with 2 columns with the exact same set up with no data in them... you take data from database 1 and put it in database 2.

assuming both databases are on the same system:

[sql]
update vbdatabase.user u, otherdatabase.credittable o
set u.newfield1=o.oldfield1, u.newfield2=o.oldfield2
where u.userid=o.userid
[/sql]