When importing Tab Delimited data into a new table, you will be presented with the following dialog to configure the available settings:

image11


ð Delimiter

Specifies which character is used as a delimiter in the source file  
 
NOTE: If your data delimiter is not listed in the drop-down list, you can specify it by typing the character in the Custom field  


ð Qualifier

Specifies which character is used to envelop non-contiguous alpha-numeric text strings which belong to a single field  
 
NOTE: If your qualifier is not listed in the drop-down list, you can specify it by typing the character in the Custom field  


ð Record Separator

Specifies which character is used as a record separator  
 
NOTE: If your record separator is not listed in the drop-down list, you can specify it by typing the character in the Custom field  


ð Charset

Specifies whether the data is based on the DOS ASCII or Windows ANSI character set  
 

ð First Row

Specifies the position of the first row of data  

NOTE: When using source files that have column headers or other information as a preface to the data, you will need to adjust this position to correspond with the row position of the first row of data to import  


ð Last Row

Specifies the position of the last row of data  
 
Default is blank to indicate all possible rows available  

NOTE: When using source files that have information as a suffix to the data, you will need to adjust this position to correspond with the row position of the last row of data to import. You can also use this value to import only a portion of an available data set within a source file by specifying the number of the last row of data that you want.