Office 2008 Planning

Working with external data sources in Excel

Excel 2008 can retrieve information from database servers, such as a computer that is running Microsoft SQL Server or other external databases by using third-party Open Database Connectivity (ODBC) drivers. After you download and install the ODBC drivers, you can use database queries to retrieve the data. The following table describes each of the query types.

Query type

Description

FileMaker

A FileMaker query is used to retrieve data from the FileMaker server. To interact with

query

a FileMaker database, users must have the FileMaker Pro application installed on

 

their client computers.

Web query

A Web query is used to query data from a specific Internet or intranet site and

 

display the information directly in an Excel 2008 spreadsheet.

 

Note Web queries are handled by Secure Sockets Layer (SSL) connections.

 

For more information about how to create Web queries, see XL98: How to Create

 

Web Query Files (KB178870) in the Microsoft Knowledge Base

 

(support.microsoft.com).

Database

A database query is used to request information from database servers, such as a

query

computer that is running Microsoft SQL Server. To use Microsoft Query in Excel

 

2008, users must first install compatible ODBC drivers on their computers so that

 

they can retrieve the data from the database.

 

For information on how to import data from a database, see Excel 2008 Help.

Text query

A text query is used to query the contents of a text file in Excel 2008.

 

 

71

Page 76
Image 76
Microsoft GZA-00006 manual Working with external data sources in Excel, Query type Description

GZA-00006 specifications

Microsoft GZA-00006 is an innovative accessory that enhances user interaction and productivity across various Microsoft devices. This product has captured the attention of tech enthusiasts and professionals alike due to its unique features and capabilities.

At its core, the GZA-00006 is designed to streamline workflow and improve efficiency. One of the main highlights of this accessory is its seamless connectivity with Microsoft devices, allowing users to switch between computer, tablet, and smartphone effortlessly. The integration is particularly beneficial for those who have adopted a mixed-device environment, as it promotes a consistent experience regardless of the platform.

A key feature of the GZA-00006 is its customizable buttons. Users can assign specific functions to each button, allowing for quick access to frequently used applications, commands, or shortcuts. This level of personalization not only saves time but also empowers users to tailor the device to suit their individual work styles and preferences.

Another standout characteristic of the GZA-00006 is its ergonomic design. Microsoft has meticulously crafted this accessory with user comfort in mind, making it ideal for extended use. The device is lightweight and fits comfortably in the hand, reducing the risk of fatigue during long working hours. The premium materials used in its construction also ensure durability, providing a reliable tool that can withstand daily usage.

Additionally, the GZA-00006 incorporates advanced wireless technology. With Bluetooth connectivity, it offers a stable and fast connection without the clutter of cables. This wireless feature not only enhances mobility but also makes it easy to pair with various devices with minimal effort.

Moreover, the device is equipped with a long-lasting battery, designed to support hours of uninterrupted usage. Users can focus on their tasks without the constant worry of recharging, which is crucial in today’s fast-paced work environment.

In conclusion, the Microsoft GZA-00006 stands out as a versatile and powerful accessory tailored for users seeking to elevate their productivity. With its customizable functionality, ergonomic design, and robust wireless capabilities, it caters to a wide range of users looking for efficiency and comfort in their daily tasks. This tool embodies Microsoft’s commitment to enhancing user experiences and supporting a collaborative and effective work atmosphere.