You run a query to perform these instructions. In addition to returning results — which can be sorted, grouped, or filtered — a query can also create, copy, delete, or change data.

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. You can also refresh your Excel reports and summaries automatically from the original source database whenever the database is updated with new information.

By default, Power Query loads queries to a new worksheet when loading a single query, and loads multiple queries at the same time to the Data Model. You can change the default behavior for all your workbooks or just the current workbook.

Describes a problem when you try to use Microsoft Query to return data from some third-party databases into Excel, apostrophes (') around alias names can cause the query to fail. We provide steps to resolve this problem.

Microsoft Support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows, Surface, and more.

When you work with a document and you try to open a Microsoft Excel file with Microsoft Query, you may receive the following error message: This data source contains no visible tables.

In Windows 11 22H2, the default app used to host console windows has been changed to Windows Terminal. After the October 2022 update, Command Prompt, Windows PowerShell, and other console apps will appear inside an instance of Windows Terminal.

When you call this procedure, Access opens the Orders form. You can create an AutoExec macro to call this procedure automatically when the database is opened.

Find help and how-to articles for Windows operating systems. Get support for Windows and learn about installation, updates, privacy, security and more.

Regedit.exe uses .reg files to import and export registry subkeys and values. You can use these .reg files to remotely distribute registry changes to several Windows-based computers.