Question

如何将多个Access不同表里的所有数据导入到同一个表里,字段名称相同

Answer 1

如果你仅仅是要连接在一起看, 用下面哪位兄台的语法即可
如果你物理性的将所有表记录复制到一个表中, 用select into 语法即可
借用下面的语法
select * into [新表名称] from
(
select col1,col2,col3 from A
union all
select col1,col2,col3 from B
union all
select col1,col2,col3 from C
union all
select col1,col2,col3 from D
union all
select col1,col3,col4 from E
)

Answer 2

select col1,col2,col3 from A
union all
select col1,col2,col3 from B
union all
select col1,col2,col3 from C
union all
select col1,col2,col3 from D
union all
select col1,col3,col4 from E
;