老生常谈表内容复制问题，请高手进来
set   conn=server.createobject( "adodb.connection ")
datafile         = "/data/data.asp "             '数据库的文件名
conn.Open   "DBQ= "&server.mappath( " "&datafile& " ")& ";DRIVER={Microsoft   Access   Driver   (*.mdb)}; "
strsql= "insert   into   news(title)   select   (T_Title)   from   MS_Topic "
conn.execute   strsql
conn.close

功能：将表MS_Topic的T_Title字段的所有内容复制到表news的title字段
执行上诉语句后没报错，也没有实现该功能
请问高手错在哪里了，谢谢

------解决方案--------------------
insert into table_name (Stock_name,Stock_number) value (select Stockname , Stocknumber from Stock_table2)---value为select语句