Details on Open Database


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 connections to use.

  1. Select File > Add Data Tables and click Add > Database....

load_open_database_d.png

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:

Opening Data from a Database