Setting Import Options - SQL Assistant

Setting Import Options

See “Setting Export/Import Options” on page 131 for more information on setting the Export/Import tab and “Setting Export Options” on page 132 for settings on the Import tab.

After selecting any of these options, follow the instructions on “Exporting Results” on page 129.

1 Select Tools > Options.

2 Click the Import tab.

3 Select the options you want.

The following table explains each option.

4 Click OK to close the Options dialog box and save your settings.

Table 27: Import Tab in the Options Dialog Box 

Option	Description
Ignore the first record in the file (Skip Header)	Skips the header when importing the file. The default value is cleared.
Convert localized decimal to a period on Import	Replaces the local decimal point character with a period, allowing data in the local format to be imported to a database that always expects the decimal point to be a period. Clear this check box if the database expects the decimal point to be a localized character. The default value is cleared.
Maximum batch size for simple imports	The number of data rows that are sent to the database at one time for Batch Import. The default batch size is 20 rows.
Silently discard rows that cause constraint violations	SQL Assistant ignores any errors that occur during the import operation and reports the number of rows that were imported and the number of rows discarded. The default value is cleared.

For more information, see “Default Preferences (Options)” on page 156.