Share via

Data Connectivity

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Microsoft® Office 2000 Developer enhances the data access scenario with a set of tools and technologies that streamline the connecting to and displaying of data in Office 2000 applications.

  • Data Connectivity Tools

  • Possible Uses for the Data Connectivity Tools

  • For More Information about Data Connectivity

Data Connectivity Tools

Today's Office solutions need to deliver data directly to the desktop from a variety of data sources. Data resides in a variety of formats and in a multitude of databases ranging from desktop to the enterprise. Developers need tools that provide high-performance access to all types of information (including relational and non-relational data) across organizations. Office 2000 Developer delivers tools and components that make it easy to integrate data into Office solutions and publish to the Web.

Feature Description
Creates connections to external databases in an easy to use interface that can easily be used within VBA to bind to data bound controls
Creates connections to external databases that can easily be used within VBA to bind to data bound controls.
Data-Aware Microsoft ActiveX® Controls Controls, such as the Hierarchical FlexGrid and DataCombo controls, that can be bound to a data source to view or edit data.
Manages the interaction between data consumers and data sources.
Quickly build sophisticated reports by dragging elements from the Data Environment without writing any code.

Possible Uses for the Data Connectivity Tools

  • **Multiple data sources on Access forms and reports   **Using the Data Environment and/or multiple ADO Data Controls and the BindingCollection object, you can view multiple sources of data on a Microsoft® Access form or report. For more information, see Adding Multiple Data Sources to an Access Form.

  • Importing and processing data sources into Excel sheets   Programmatically import data into a Microsoft® Excel worksheet using an add-in. For example, replace figures in an existing column of a report. For more information, see Displaying Data from a Recordset in an Excel Worksheet.

  • **Dynamic data slides in PowerPoint   **Use an ADO Data control connected to a DataGrid control, and show the most current data available. Or use a Microsoft® Chart control bound to a numeric field to show a chart of current figures. For more information, see Displaying a Data-bound Chart Control on a PowerPoint Slide.

  • **Data entry forms   **Use the Microsoft® Visual Basic® UserForm to create an application that updates a database with selected data found in a Microsoft® Word document. For more information, see Displaying a Hierarchical FlexGrid on an Access Form.

  • **Dynamic data display   **On a Visual Basic UserForm, display data in a DataGrid based on data in a document. For example, display a customer's history by selecting a name found in a document. For more information, see Displaying Data from a Data Source.

For More Information about Data Connectivity

This documentation provides information about how to use these tools in the Visual Basic for Applications (VBA) 6.0 environment. For more information about the tools and controls themselves, see the .

To learn about See
How data is accessed using Office 2000 Developer Accessing Data Using Office 2000 Developer Tools
What a data source is and how they are created in Office 2000 Developer Creating a Data Source Using Data Connectivity Tools
How to display data in Office 2000 Developer applications, including example code for Office 2000 applications Displaying Data from a Data Source

A Note on the Documentation

The documentation for the data connectivity tools was originally created for use in Visual Basic 6.0. However because of slight differences between the VBA programming environment (Visual Basic Editor) and Visual Basic 6.0, there are some (consistent) differences. While consulting the documentation, please keep the following differences in mind.

  • Setting the DataSource property

    Visual Basic Editor Visual Basic 6.0
    The property is not available on the Properties sheet. Instead you must set it at run time using the following code: 
    Set Datagrid1.DataSource = DataEnvironment1
    		 You can set the property at design time using the Properties sheet.

  • Adding a DataEnvironment or DataReport designer to a project

    Visual Basic Editor Visual Basic 6.0
    The designers can only be added to a new project. You can add a designer to any project.

  • Switching from run mode to design-time mode

    Visual Basic Editor Visual Basic 6.0
    Click the Design Mode button on the toolbar to stop the project. Click the Stop button on the toolbar.