Setting up advanced data connectivity

To use advanced data connectivity to export data to and import data from a Microsoft Access, SQL Server, or Oracle database, or an Excel file, complete the following tasks:

Prepare the database to produce and receive data.

Choose the type of database connection that supports the export or import.

Create a database connection.

Use ADO to create an OLE-DB link.

Alternatively, define a data link string when you create the database connection.

Create a data import or data export.