Hi, Is it posible to insert single colume value from one DSN table to another DSN table. table: DSN1 Name Adrress City aaa bbbb xxx ccc sss yyy table: DSN2 Phone Job City eee ttt qqq kkk Finally the DSN2 table look like table: DSN2 Phone Job City eee ttt xxx qqq kkk yyy Any sql quely like inserting DSN1table City values into DSN2table City. I used this query but giving some problem "insert into UserInfo (CITY) in 'C:\\User.mdb' select CITY from RateInfo"; its inserting the city value but remailning null, I mean not in a perticular row. Help would be appriciated. Thanks, Ahamed.