在access作為source中,以sql query為source.select a.userid,a.Q1A,a.Q1B from USERANSWER a union all select b.userid,b.Q2A,b.Q2B from USERANSWER b order by userid
insert into USER_info select a.userid,a.Q1A,a.Q1B from USERANSWER a order by useridgo insert into USER_info select b.userid,b.Q2A,b.Q2B from USERANSWER b order by userid
在access作為source中,以sql query為source. 1.Source: select a.userid,a.Q1A,a.Q1B from USERANSWER a union all select b.userid,b.Q2A,b.Q2B from USERANSWER b order by userid2.Destination: 選擇 table USER_info3.Tranfor: 直接columns copy
非常感谢playwarcraft()的SQL语句,我根据你的改了一下,成功了! //------------------------------ select [id],[date],[week],1 as Q2,[Q301] as Q3 FROM 结果 union all select [id],[date],[week],2,[Q302] FROM 结果 union all select [id],[date],[week],3,[Q303] FROM 结果 union all select [id],[date],[week],4,[Q304] FROM 结果 union all select [id],[date],[week],5,[Q305] FROM 结果 union all select [id],[date],[week],6,[Q306] FROM 结果 union all select [id],[date],[week],7,[Q307] FROM 结果 union all select [id],[date],[week],8,[Q308] FROM 结果 union all select [id],[date],[week],9,[Q309] FROM 结果 union all select [id],[date],[week],10,[Q310] FROM 结果 union all select [id],[date],[week],11,[Q311] FROM 结果 union all select [id],[date],[week],12,[Q312] FROM 结果 order by [id],[date],Q2
select a.userid,a.Q1A,a.Q1B from USERANSWER a
order by useridgo
insert into USER_info
select b.userid,b.Q2A,b.Q2B from USERANSWER b
order by userid
1.Source:
select a.userid,a.Q1A,a.Q1B from USERANSWER a
union all
select b.userid,b.Q2A,b.Q2B from USERANSWER b
order by userid2.Destination:
選擇 table USER_info3.Tranfor:
直接columns copy
//------------------------------
select [id],[date],[week],1 as Q2,[Q301] as Q3
FROM 结果
union all
select [id],[date],[week],2,[Q302]
FROM 结果
union all
select [id],[date],[week],3,[Q303]
FROM 结果
union all
select [id],[date],[week],4,[Q304]
FROM 结果
union all
select [id],[date],[week],5,[Q305]
FROM 结果
union all
select [id],[date],[week],6,[Q306]
FROM 结果
union all
select [id],[date],[week],7,[Q307]
FROM 结果
union all
select [id],[date],[week],8,[Q308]
FROM 结果
union all
select [id],[date],[week],9,[Q309]
FROM 结果
union all
select [id],[date],[week],10,[Q310]
FROM 结果
union all
select [id],[date],[week],11,[Q311]
FROM 结果
union all
select [id],[date],[week],12,[Q312]
FROM 结果
order by [id],[date],Q2