Examples of using Microsoft query in English and their translations into Vietnamese
{-}
-
Colloquial
-
Ecclesiastic
-
Computer
Qry format for use with earlier versions of Microsoft Query that cannot open. dqy files.
Microsoft Query uses the data source to connect to the external database and to show you what data is available.
For more information about changing a query, see Microsoft Query Help.
The OLAP Cube Wizard in Microsoft Query, which created an OLAP Cube from a Jet database, is no longer available in Excel.
Qry format that you want to use in Excel, open the file in Microsoft Query, and then save it as a. dqy file.
Fortunately, Microsoft Query is an alternative that is available in all versions of Excel that can guide you through the process.
For more information about connecting to a data source and using Microsoft Query, see Microsoft Query Help.
When you open these files in Microsoft Query, you can view the data returned by the query and modify the query to retrieve different results.
For more information about constructing and editing queries in Microsoft Query, see Microsoft Query Help.
Microsoft Query provides a simple front end, easily accessible from within Excel, to perform these specialized query tasks.
When you use the Multi-Dimensional Connection Wizard in Microsoft Query to create a data source for an OLAP database or cube, an.
By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that you want to analyze in Excel.
For more information about constructing and editing queries in Microsoft Query, see Microsoft Query Help.
Microsoft Query You can use Query to retrieve data from an external database such as Microsoft SQL or Microsoft Access.
Note: When you retrieve data from a database,any changes to column names in Microsoft Query are retained in the external data range.
You can customize a Microsoft Query or Web query parameter query by changing the prompt, by using data from a cell as the prompt, or by using a constant.
To import data from a database, such as Microsoft SQL Server,you must have an ODBC driver that is compatible with Microsoft Query installed on your computer.
Addressed additional issues with Cortana, Microsoft Query and Microsoft Excel compatibility, and the Korean Input Method Editor(IME).
Excel Services does not support external data ranges, which means that Excel Services does not support an Excel Table connected to a data source, a Web query, an XML map, or Microsoft Query.
You can change the underlying query for anexternal data range that was created from Microsoft Query, an imported text file, a Web query, or the Data Connection Wizard.
In Microsoft Query, click Options on the Edit menu, select the Limit number of records returned to check box under User settings, and then enter the maximum number of records to return in the Records box.
Note: The following procedure applies only to an external data range that iscreated by using the Data Connection Wizard or Microsoft Query(and not to an imported text file or Web query), an external data range converted from a Microsoft Office 2003 program, or an external data range created programmatically.
In Microsoft Query, you can use the Query Wizard to create a simple query, or you can use advanced criteria in Query to create a more complex query and do the following.
After you create your query and return the data to Excel, Microsoft Query provides the Excel workbook with both the query and data source information so that you can reconnect to the database when you want to refresh the data.”.
In Microsoft Query, you can use the Query Wizard to create a simple query, or you can use advanced criteria in Query to create a more complex query and do the following.
By using the Data Connection Wizard and Microsoft Query, you can also access many other data sources that have the appropriate OLE DB providers and ODBC drivers, including other Excel worksheets, Microsoft FoxPro, dBASE, Paradox, Oracle, and DB2.
Using Microsoft Query, you can connect to external data sources, select data from those external sources, import that data into your worksheet, and refresh the data as needed to keep your worksheet data synchronized with the data in the external sources.….
How Microsoft Query uses data sources After you set up a data source for a particular database, you can use it whenever you want to create a query to select and retrieve data from that database- without having to retype all of the connection information.