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.
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.