Bob: Are you sure you need to use a specification file? In addition to using the sheet index, you can also map columns to table names:
GATEWAY IMPORT XLS filename APPEND customer OPTION ADD_MAPPING Company=B | ADD_MAPPING CustAddress=C | ADD_MAPPING City=D Karen > Jan, > > Thanks for the response. > > I am using 7.5 and Gateway will import the selected tab of the xls work > book fine, > > if I use the GUI method. What I need to do is use the command line while > only selecting > > certain columns from the spread sheet.. > > > > However, looking at RDOCS, I see an option "SHEET_INDEX 0" that is not > in my standard > > help files. This looks like what I need, however, RDOCS does not show > the > > "Specification_File_Name" option which I would need as well. So help > shows the > > context for using a specification file at the command prompt but not the > sheet index > > number. RDOCS shows the sheet index number option but not the file > specification option. > > > > I have not had time to experiment, but perhaps even though not listed, > both the > > "Sheet_Index" and "Specification_File_Name" will work together. I will > give it > > a try later today. > > > > Thanks, > > -Bob > > >
