Dennis: Hmmm... You're right. I have the syntax in my notes document, but I don't see the "add_mapping" in the version of help that I have. But I just tried it here with a small example and it totally ignores the mapping. Seems like this would be a very useful option, easier than going thru a spec file.
Does anyone use the "add_mapping" option of an excel import and have it working? Karen > Nope, that didn’t work. > > But I did discover I could make a table 11 columns wide and import into > that. > > I can extract what I need from that table. > > Dennis > > > From: [email protected] [mailto:[email protected]] On Behalf Of > [email protected] > Sent: Monday, June 07, 2010 4:39 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Import from excel to 7.6 > > > > > Dennis: I've never actually done this, but my notes have the > following syntax: > > GATEWAY IMPORT XLS filename APPEND customer > OPTION ADD_MAPPING Company=B > | ADD_MAPPING CustAddress=C > | ADD_MAPPING City=D > > This would bring in only columns BC&D from the spreadsheet. > > Karen > > > >
