For example, if your data is stored in an Access database, you might want to know the sales figures for a specific product by region. Selecting data from a database You retrieve data from a database by creating a query, which is a question that you ask about data stored in an external database. For information about installing an ODBC driver or data source driver that is not listed here, check the documentation for the database, or contact your database vendor. You can use also ODBC drivers or data source drivers from other manufacturers to retrieve information from data sources that are not listed here, including other types of OLAP databases. Microsoft SQL Server Analysis Services (OLAP provider) Microsoft Office provides drivers that you can use to retrieve data from the following data sources: You can also retrieve data from Excel workbooks and from text files. 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.
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.
0 kommentar(er)
