Karen,
I have been reading this discussion with interest. I use the specification file daily for a couple of Excel files. I use it for many reasons but one is the number of rows imported varies wildly in one of the files and I change that setting each day. If I were to use the below SYNTAX as you suggest, is there on option for the rows imported? In the past before I used the rows setting, the import would take much longer because RBASE seemed to "LOOK" at all the rows even if they contained no information. With 7.6 is the rows setting not that important? Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, May 11, 2009 3:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: File Gatway option question 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
