Configure OLE DB Connection Manager
SQL Server 2012
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 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.
Show: