Use the following procedure to set import options in the Options dialog. See Setting Export/Import Options for more information on setting the Export/Import tab and Setting Export Options for Export tab settings.
After selecting any of these options, follow the instructions on Exporting Results to learn how to export results.
For more information, see Default Preferences (Options).
- Select .
- Click the Import tab.
-
Select the options you want.
Option Description Ignore the first record in the file (Skip Header) Skips the header when importing the file.
The default 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.