Changing Adapter Settings

To change the settings for the adapter, right-click the adapter on the Adapters page and select Change Settings.

The Change Settings for Excelpage opens, as shown in the following image.

You can change the following settings.

EXCEL-SHEET

Select Multiple sheet selection (the default) or Single sheet selection from the drop-down list. Your selection affects whether you can select multiple worksheets or only a single worksheet when uploading a file using the Upload Wizard feature.

FETCHSIZE

Implements buffered retrieval. Enter a number of rows or accept the default value (100).

Select profile

Select a profile to contain these settings from the drop-down list.