Export (0) Print
Expand All

Configure OLE DB Connection Manager

Updated: 12 December 2006

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.

ms186579.note(en-US,SQL.90).gifNote:
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.

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.

Release History

12 December 2006

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft