在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
union all
select b.userid,b.Q2A,b.Q2B from USERANSWER b
order by userid
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