Load Data window

Input file
Type a directory path to a .data file, or click Browse to open a window so that you can look for a file.
File format
Specify options for the format of the .data file. You must ensure that the format that you specify is the same format that the input file uses.
Column delimiter
Specify the character to use as a column delimiter in the .data file.
Character string delimiter
Specify the character to use as a string delimiter in the .data file.
Replace existing data
Select to specify that all existing data is deleted and replaced with the data from the .data file. If you do not specify this option, the table is directly loaded and any existing rows are preserved. There is a possibility when you do not replace existing data that data might be duplicated. If data is duplicated and the table has unique constraints or unique indexes, the load might fail.

Feedback