insert
into
www_templet (tid,name,templet,content,content1,url,url1,
[
time
]
,
[
admin
]
,qx,city,isoverWrite,isGlobal)
select
tid,name,templet,content,content1,url,url1,
[
time
]
,
[
admin
]
,qx,city,isoverWrite,isGlobal
from
[
Dichan_News
]
.
[
dbo
]
.
[
Sheet1$
]
insert into 复制进数据的表 (字段1,字段2...) select 字段1,字段2... from 要复制数据的表 where 条件。。。