Share via


Configure OLE DB Connection Manager

Use the Configure OLE DB Connection Manager dialog box to add a connection to a data source, which can be either a new connection or a copy of an existing connection.

Note

If the data source is Microsoft Office Excel 2007, the data source requires a different connection manager than earlier versions of Excel. For more information, see How to: Connect to an Excel Workbook.

If the data source is Microsoft Office Access 2007, the data source requires a different OLE DB provider than earlier versions of Access. For more information, see How to: Connect to an Access Database.

To learn more about the OLE DB connection manager, see OLE DB Connection Manager.

Options

  • Data connections
    Select an existing OLE DB data connection from the list.

  • Data connection properties
    View properties and values for the selected OLE DB data connection.

  • New
    Create an OLE DB data connection by using the Connection Manager dialog box.

  • Delete
    Select a data connection, and then delete it by using the Delete button.