老生常谈表内容复制问题，请高手进来
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语句
