excel导入access数据时提示数据源中没有包含可见的表格

zhjsyf

excel导入access数据时提示数据源中没有包含可见的表格，我返回access运行查询时都没有问题啊，请问是什么原因？谢谢啦

zhjsyf

是这样的，我里面有个项目用表达式生成器做了个公式：1月份期初库存: nz([1月份订单金额])+nz([1月份期初库存、仓位]![1月1日总部可用库存])。我删除了这个后，excel的链接就正常了。是不是我这个表达式影响了？

wuxiang_123

EXCEL不支持Nz函数。请用IIF(ISNULL(表达式),0,表达式)代替Nz函数

zjjustin

我也遇到了类似的问题，在access里面可以运行。但是到了excel 里面就找不到那个表格。我的公式如下：请问需要如何修改？
SELECT Q2_group_by_forecast.months as Month,Q2_group_by_forecast.ph3 as PH3,Q2_group_by_forecast.[ship to code] as [ship to code],0 as[volume budget],0 as [NS budget],0 as [CM budget],Q2_group_by_forecast.[volume forecast] as [volume forecast],Q2_group_by_forecast.[NS forecast] as [NS forecast],Q2_group_by_forecast.[CM forecast] as [CM forecast] from Q2_group_by_forecast

UNION

select Q2_months_budget.months as Month,Q2_months_budget.ph3 as PH3,Q2_months_budget.[ship to code] as [ship to code],Q2_months_budget.[volume budget] as [volume budget],Q2_months_budget.[NS budget] as [NS budget],Q2_months_budget.[CM budget] as [CM budget],0 as [volume forecast],0 as [NS forecast],0 as [CM forecast] from Q2_months_budget;