从查询创建表（SQL视图） [英] Make a Table from a Query (SQL View)

问题描述

我使用sql视图创建了一个查询，并希望将此查询作为一个表。有什么方法可以做到这一点。我已经尝试点击查询 - 生成表查询，但这将我带到设计视图，它完全忽略了我在sql视图中的内容。


谢谢

i have created a query using the sql view, and want to make this query a table. is there any way i can do that. i have tried clicking on query-make table query, but this takes me to the design view and it completely neglects what i had in sql view.

Thanks

推荐答案

所以你想根据SELECT查询的结果创建一个表？

So you want to make a table based on the results of a SELECT query?

使用Access 2003，我在SQL视图中创建了一个SELECT查询。然后我点击了Query-> Make-Table查询...并将Access切换到设计视图，从我的SQL视图中正确填写网格。

我看到一个对话框要求换一个新表名称，以及是否在此数据库或其他数据库中创建。

我给出了一个名称并选择了当前数据库。我被置于设计视图中。

更改为SQL视图，我的SQL语句现在已正确更改为生成表查询。


当您发生了什么事点击查询>点击查询 - >生成表查询...？

Using Access 2003, I created a SELECT query in SQL view. I then clicked Query->Make-Table query... and Access switched to design view, correctly filling in the grid from my SQL view.
I was presented with a dialog asking for a new table name, and whether to create in this database or another.
I gave a name and chose current database. I was left in design view.
Changing to SQL view, my SQL statement was now altered correctly to a make-table query.

What happened when you clicked Query->Make-Table query...?

使表查询访问切换到设计视图，但网格为空，并且没有填写任何字段

when i click query> make table query access switches to design view, but the grid is empty, and has no fields filled out

这篇关于从查询创建表（SQL视图）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！