O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The DTS Wizard

To start the DTS Import/Export Wizard, select Start, then Microsoft SQL Server, then Import and Export Data, which activates the DTS Import/Export Wizard, click next, and the Choose A Data Source wizard screen appears, as shown in Figure 22-1. This is where you determine the data source by using the Source combo box to choose the required OLE DB, ODBC, or Indexed Sequential Access Method (ISAM) driver. Depending on the source chosen, the corresponding fields in that group are displayed. The following example uses the ContosoSQL database on the local server.

More Information

The DTS Import/Export Wizard can be activated through various context menus within the SQL Server Enterprise Manager console as Import Data or Export Data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required