This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
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.