如何以查询方式将查询的记录转换为表 [英] How to convert a query's record to table in access programitically

问题描述

如何将查询的输出记录转换为Access中新表的记录？



先谢谢

How to convert a query's output record to a new table's records in Access?

Thanks In advance

推荐答案

如果该表不存在则

SELECT Table1.[ID], Table1.[Field1], Table1.[Field2], Table1.[Field3] INTO Table2 FROM Table1;

如果表已经存在然后

INSERT INTO Table2
SELECT Table1.[ID], Table1.[Field1], Table1.[Field2], Table1.[Field3]
FROM Table1;

我切换到SQL View来执行此操作。抱歉，我不知道如何在Access'Design View

I switched to SQL View to do this. Sorry I don't know how to do it in Access' Design View

中

这篇关于如何以查询方式将查询的记录转换为表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！