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 > I need to import data from 150 excel spreadsheets into a table. > > I only need to pull columns A, G, K > > I can supply the filename of each spreadsheet. > > What syntax can I use to accomplish this? > > > > I was going to use the gateway interface, but the spreadsheets have > almost all possible columns populated. > > Unclicking these is going to take forever! > > If I could start the interface with the columns all unchecked it would be > easy. > > > > Any suggestions? > > > > Thanks, > > Dennis McGrath > > > > > > > > >
