On
the authoring bar, click Files and data
.
In the Files and data flyout, click Other. and then click Load Data with ODBC, OLE DB, or ADO.NET data provider.
It is recommended to use a data connection or an information link to retrieve your data rather than the data provider access described below, if this is possible. See Open from Database Overview for some tips on what to use in different situations.
To reach the Open Database dialog:
On
the authoring bar, click Files and data
.
In the Files and data flyout, click Other. and then click Load Data with ODBC, OLE DB, or ADO.NET data provider.
Option |
Description |
Data
source type |
Lists the available data source types. |
Connection
string |
Shows the connection string specified for the selected data source type. If no connection has been defined yet you can do that by clicking Configure.... |
Configure... |
Opens the Configure Data Source Connection dialog for the respective data source type: ODBC, OLE DB, OracleClient, SQLClient or a custom provider. |
See also: