数据源
A
1
2
3
4
5
6
7
8
9
Sql = "Select A"
Sql = Sql & " From [Sheet3$] "
Sql = Sql & "Where A Between 2 and 4"
RST输出结果为
2
3
4
目标要求结果A1 -- A2 -- A3 -- A4 -- A5
1 -- 2 -- 5 -- 7 -- 9
3 -- 6 -- 8 --
4 --
A
1
2
3
4
5
6
7
8
9
Sql = "Select A"
Sql = Sql & " From [Sheet3$] "
Sql = Sql & "Where A Between 2 and 4"
RST输出结果为
2
3
4
目标要求结果A1 -- A2 -- A3 -- A4 -- A5
1 -- 2 -- 5 -- 7 -- 9
3 -- 6 -- 8 --
4 --
Sql = Sql & " (select A as m "
Sql = Sql & " From [Sheet3$] "
Sql = Sql & "Where A Between 2 and 4"
Sql = Sql & " ) T "
只能做到T.m
要生成T.m,T.m1,T.m2试一下。