Examples of using Microsoft query in English and their translations into Slovak
{-}
-
Colloquial
-
Official
-
Medicine
-
Financial
-
Ecclesiastic
-
Official/political
-
Computer
-
Programming
For external data ranges that are created from Microsoft Query and the Data Connection Wizard,
A data source is a stored set of information that allows Excel and Microsoft Query to connect to an external database.
editing queries in Microsoft Query, see Microsoft Query Help.
This tab is available only if you ran Microsoft Query from Excel.
Change the underlying query for an external data range created from Microsoft Query Click a cell in the external data range for which you want to change the underlying query. .
The OLAP Cube Wizard in Microsoft Query, which created an OLAP Cube from a Jet database,
This tab is available only if you ran Microsoft Query from Excel.
On the Data tab, in the Get External Data group, click From Other Sources, and then click From Microsoft Query.
Note: When you retrieve data from a database, any changes to column names in Microsoft Query are retained in the external data range.
either by using the Query Wizard or directly in Microsoft Query.
further refine the query in Microsoft Query.
either by using the Query Wizard or directly in Microsoft Query.
After you create a query in either the Query Wizard or Microsoft Query, you can return the data to an Excel worksheet.
Reusing and sharing queries In both the Query Wizard and Microsoft Query, you can save your queries as a.
Using Microsoft Query, you can join these tables
Using Microsoft Query to import data to import external data into Excel with Microsoft Query, follow these basic steps,
When clear, applications that use quoted identifiers, such as the Microsoft Query utility that comes with Microsoft Excel,
When you use Microsoft Query to set up a data source,
return the data to Excel, Microsoft Query provides the Excel workbook with both the query and data source information so that you can reconnect