Gesproken tekst vertalen, offlinefuncties, synoniemen, vervoegingen, educatieve spelletjes
Publiciteit
Registreer gratis: toegang tot meer resultaten en functies
query external data source
Examples with "query external data source" and their translation in Chinees
Query external data source as you select each report filter field item (requires less memory)
每选择一个报表筛选字段项都检索外部数据源（节省内存）
This connection cannot be used because it is already used by another PivotTable report created in one of the following ways: With the Query external data source as you select each report filter field item option in the PivotTable Field Advanced Options dialog box selected With the Optimize memory check box in the PivotTable and PivotChart Wizard Options dialog box selected To change these options, you must use the PivotTable and PivotChart Wizard (with the PivotTable report selected, press ALT+D+P). To add this wizard to the Quick Access Toolbar, click the Microsoft Office Button, click Excel Options, click Customize, and then add the PivotTable and PivotChart Wizard button (For more information, click the Help button on the Excel Options title bar). To create a new connection for this PivotTable report, select a connection file in the Connection files on this computer section below.
不能使用此连接，因其已被以以下方式之一创建的其他数据透视表使用： 选中了数据透视表字段高级选项对话框中的所有报表筛选字段项目选项的同时选择使用查询外部数据源 选中了数据透视表和数据透视图对话框中的优化内存复选框 若要更改这些选项，必须使用数据透视表和数据透视图向导（选中数据透视表后按 ALT+D+P）。若要将此向导添加到快速访问工具栏，请单击 Microsoft Office 按钮，单击"Excel 选项"，然后单击"自定义"，再单击"数据透视表和数据透视图"按钮（有关详细信息，请按 Excel 选项标题栏上的"帮助"按钮）。 若要为此数据透视表创建连接，请从以下的此计算机节上的连接文件中选择一个连接文件。
This PivotTable has the "Query external data source as you select each report filter field item" option turned on and slicers cannot be used with this option.To connect slicers to this PivotTable, first turn off the "Query external data source as you select each report filter field item" option.
Query external data source as you select each page field item (requires less memory)
Andere resultaten
In Reporting Services, report definitions include one or more queries, layout information, and data source connections to the external data sources used in the report.
External data sources are used to import data into Excel, but connections to external data sources can be used by queries to access confidential information available to other users, or to perform other harmful actions. If you trust the source of this file, click OK.
First make sure the Use The Query Wizard To Create/Edit Queries option is checked, if present. Next, specify a source for the external data you want to retrieve. Choosing from the list of databases, queries, or OLAP cubes that are already defined is the easiset way to start a new query. If the data source you want has not been defined, choose New Data Source and follow the instructions to create a new data source. For more information, click a button below
Changes to the Background Query option also change the option for other PivotTable reports based on the same source now on, when you refresh the other reports, the query for external data will also be run in the background.
Performing this operation requires using a query to refresh external data. A malicious user can design a query to access confidential information and distribute it to other users or perform other harmful actions. If you trust the source of this workbook, click OK to query and refresh the you are not sure, click Cancel so that changes are not applied to your workbook.
Your query might not have selected any data, your MS Query data sources may not be set up correctly, or there may be a problem with the connection to the external database. Create the query again. Verify that you can connect to your external database and view the sure the Query Wizard or the MS Query window is displaying the correct data before you return the data to Microsoft Office Excel.
Excel cannot open FoxPro.dbc files. To import FoxPro data into Excel, use the Get External Data command: In Excel, click From Other Sources (Data tab, Get External Data group), and then create a query to retrieve the information about creating a query, see Help in Excel.
This wizard helps you specify a data connection to an external data source.
本向导帮助您指定一个到外部数据源的数据连接。
Click here to discover external data sources and define operations.
单击此处发现外部数据源并定义操作。
Ga naar Premium voor toegang tot miljoenen vertaalvoorbeelden, onbeperkt woorden opslaan en leren, zonder advertenties.
Woord & uitdrukking van de dag
Afbeelding van de dag
Resultaten: 5632. Exact: 4. Verstreken tijd: 45 ms.
