Hi but confused here i have MS Sql server express 2005. what i was hoping to do was to copy a column from one table to another in the same DB basically both tables have a link key so i wanted to just add the data not the key, but obviously i wanted to add the data to the correct rows. tried this but i am getting an error saying that the column "OTHERSTUFF"does not exist and i know it does.

Code:
Dim StrSql As String
            
            
            StrSql = "INSERT INTO Table_WARE (MYSTUFF) SELECT MYSTUFF FROM Table_OTHERS WHERE MYSTUFFKEY=OTHERSKEY;"
            rs.Open StrSql, cn, , adLockPessimistic, adCmdText
Both tables have the data in them and allready have the columns one empty ofcoures ready to recieve the data i know i was given a example in a previous but this was for a differnt application and selects all the records i only want to add one column