Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

System_CAPS_noteNote

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 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 Connect to an Access Database.

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

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.

Community Additions

ADD
Show:
© 2015 Microsoft