检索数据之前的OLEDB更新 [英] OLEDB update before retrieve data

问题描述

您好，

我遇到以下问题：

我需要连接到没有返回数据的OLEDB提供程序一些表，除非你更新表中的某些特定值。

I need to connect to an OLEDB provider that is not returning data for some tables unless you update some specific values in a table.

在示例中，我需要从Tasks表中获取数据，在此之前我必须将scope_level更新为Projects数据。

In example i need to get from Tasks table the data and before that i have to update scope_level to Projects data.

这是指针对Oracle Primavera的SDK。

This refers to SDK for Oracle Primavera.

我已联系过他们并告诉我，只有programmaticaly你可以运行这样的脚本（VBA更新），但我想知道是否这也可以通过获取外部数据来使用Excel中的Power Pivot / Tables和Power Pivots。

I have contacted them and told me that only programmaticaly you can run such scripts (VBA for update) but I wonder if this is also possible through the Get External Data in order to work with Power Pivot / Tables and Power Pivots in Excel.

即：在MS Access中设置连接很容易相关表，然后运行更新查询到Projects表以更新所需的值，你可以正常工作。

I.e: In MS Access is easy as you set up the connection and the relevant tables, then run an update query to the Projects table to update the required values and you can work fine.

Excel的任何简单解决方案？

Any simple solution for Excel?

推荐答案

>>>在示例中我需要从Tasks表中获取数据并在此之前我必须将scope_level更新为Projects数据。

>>>In example i need to get from Tasks table the data and before that i have to update scope_level to Projects data.

通过获取外部数据这是不可能的，以便在Excel中使用Power Pivot / Tables和Power Pivots。

我认为只能通过编程方式运行此类脚本（VBA进行更新）。

This is impossible through the Get External Data in order to work with Power Pivot / Tables and Power Pivots in Excel.
I think that only programmatically you can run such scripts (VBA for update).

这篇关于检索数据之前的OLEDB更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！