MS Access 2010 SQL选择进入计算列问题 [英] MS Access 2010 SQL Select Into Calculated Column Issue

问题描述

我有一个相当广泛的带有查询列的Union查询，我试图通过单独的SELECT INTO查询将值粘贴"到表中.执行查询时出现以下错误.不使用VBA可以解决此问题吗?

I have a pretty extensive Union query with calculated columns that I'm trying to just "paste values" into a table through a separate SELECT INTO query. I get the error below when executing the query. Is there any way around this without using VBA?

"SELECT INTO语句中不允许使用计算列."

"Calculated columns are not allowed in SELECT INTO statements."

对于上下文: 通常，我可以通过Excel中的PowerPivot链接到联合查询，但是由于某种原因PowerPivot无法识别联合查询.如果我导出联合查询然后导入为表格，则PowerPivot会识别它.

For context: Normally, I'd be able to link up to the union query through PowerPivot in Excel but for some reason PowerPivot does not recognize the union query. If I export the union query then import as a table, PowerPivot recognizes it.

推荐答案

感谢@HansUp的帮助.

Thanks to @HansUp for the help.

我用UNION查询中的适当标题设置了一个空白表，并使用INSERT INTO查询而不是SELECT INTO来将UNION查询数据放入表中.

I set up a blank table with the appropriate headers from the UNION query and used an INSERT INTO query rather than a SELECT INTO to get the UNION query data into the table.

这篇关于MS Access 2010 SQL选择进入计算列问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！