在Access中从另一个表的数据创建一个表 [英] Creating one table from data of another table in Access

问题描述

这个问题与MS Access有关.

This question is regarding MS Access.

我想做的是在Access中有一个表，并希望使用第一个表中的数据创建另一个表(希望通过某些VBA代码自动创建).

What I'm trying to do is that I have one table in Access, and would like to create another table (hopefully automatically through some VBA code) using data from the first table.

关于如何执行此操作有任何建议吗?我在VBA和Access方面还很陌生，因此希望获得任何详细的帮助(或说明操作方向).

Is there any suggestion on how to do this? I'm quite new in VBA and Access so any detailed help would be appreciated (or direction on where to go).

原始表(表1数据):

原始表(表1的结构):

Original Table (table 1 structure):

表2数据:

表2结构:

推荐答案

不需要VBA. UNION查询可以重新排列数据.在查询生成器的SQLView中，没有用于UNION查询，键入或复制/粘贴的向导或设计器.另外，最多只能有50条SELECT行.

No VBA is needed. A UNION query can rearrange the data. There is no wizard or designer for UNION query, type or copy/paste in SQLView of query builder. Also, there is a limit of 50 SELECT lines.

SELECT ID AS IDFromTable1, EmployeeName, Ford AS CarManufacturer FROM Table1
UNION SELECT ID, EmployeeName, Mazda FROM Table1
UNION SELECT ID, EmployeeName, Honda FROM Table1
UNION SELECT ID, EmployeeName, Toyota FROM Table1
UNION SELECT ID, EmployeeName, Audi FROM Table1
UNION SELECT ID, EmployeeName, Volkswagon FROM Table1
UNION SELECT ID, EmployeeName, BMW FROM Table1
UNION SELECT ID, EmployeeName, Benz FROM Table1;

这篇关于在Access中从另一个表的数据创建一个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！