且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

访问-将某些列数据转置为行记录

更新时间:2023-11-18 21:47:04

或者,考虑可以同时使用Jet/ACE引擎(Windows .dll文件)在Excel或Access中运行的SQL联合查询:>

Alternatively, consider an SQL union query which can be run in either Excel or Access, both using the Jet/ACE engine (Windows .dll files):

SELECT Col1, Col2, Col3
FROM TableOrSheet$Name
UNION ALL
SELECT Col1, Col2, Col4
FROM TableOrSheet$Name
UNION ALL
SELECT Col1, Col2, Col5
FROM TableOrSheet$Name
UNION ALL
SELECT Col1, Col2, Col6
FROM TableOrSheet$Name