I am using VB6 to execute an sql statement. I have two access tables and want to insert the contents of a field in one into the other subject to the key no being the same. I have been unable to get it to work and would appreciate some help. I have:
update mytable set mytable.fieldx = othertable.fieldx where mytable.keyno = othertable.keyno
Any offers please?