Hello Group:

I am trying to automate a gateway import routine using 7.1 update 75

My question how do you tell gateway to import the data starting a specific
row number ? 
I will be using the data always start on the 2nd row with the first row
listing the column names.

Since I am importing into a rbase table that contains integer values I need
to strip out the first row.

I can manually open each file and remove the 1st row but my objective is to
do this without user intervention.

The command that I am using to works great after I remove the 1st row with
the column names.

GATEWAY IMPORT XLS \ncm_iso\fh_nf.XLS replace fh_se_nf OPTION SHEET_INDEX 0

I have read all the documentation on gateway import but I cannot find any
mention of this.


TIA

Larry Wilson

Reply via email to