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

To connect to a data source that uses Microsoft Office Excel 2003 or earlier, use an Excel connection manager. For more information, see Excel Connection Manager. To connect to a data source that uses Microsoft Office Excel 2007, use an OLE DB connection manager, and for Provider, select Microsoft Office 12.0 Access Database Engine OLE DB Provider. Then, on the All page of the Connection Manager dialog box, for Extended Properties, enter Excel 12.0. To load data from or to an Excel 2007 data source, use an OLE DB source or an OLE DB destination, respectively. You cannot use an Excel source or an Excel destination to load data from or to an Excel 2007 data source. To connect to a database that uses Microsoft Office Access 2003 or earlier, use an OLE DB connection manager, and then for Provider, select Microsoft Jet 4.0 OLE DB Provider. To connect to a database that uses Microsoft Office Access 2007, use an OLE DB connection manager, and then for Provider, select Microsoft Office 12.0 Access Database Engine OLE DB Provider. To connect to data sources that use Excel 2007 or Access 2007, you cannot select Microsoft Jet 4.0 OLE DB Provider.

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.

See Also

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

12 December 2006

New content:
  • Added a note about the use of either Excel 2007 or Access 2007 data sources.