Microsoft Query is a program for retrieving data from external sources into other Microsoft Office programs — in particular, Microsoft Excel
Microsoft Query is a program for bringing data from external sources into other Microsoft Office programs — in particular, Microsoft Excel. By using Query to retrieve data from your corporate databases and files, you don't have to retype the data you want to analyze in Excel. You can also update your Excel reports and summaries automatically from the original source database whenever the database is updated with new information.
Types of databases that you can access
You can retrieve data from several types of databases, including Microsoft Office Access, Microsoft SQL Server, and Microsoft SQL Server OLAP Services. You can also retrieve data from Excel workbooks and from text files.
Microsoft Office provides drivers that you can use to retrieve data from the following data sources:
- Microsoft SQL Server Analysis Services (OLAP provider)
- Microsoft Office Access
- dBASE
- Microsoft FoxPro
- Microsoft Office Excel
- Oracle
- Paradox
- Text file databases
