Larry What I've done in the past was to create a TEMPORARYtable with all text columns.
Import the XLS into the TEMPORARYtable. delete row from TEMPORARYtable WHE COUNT = 1 OUT filename Unload data from TEMPORARYtable AS ASCII OUT term LOAD realTABLE FROM filename as ascii Buddy -----Original Message----- From: Larry Wilson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 10:35 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: gateway import question 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
