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 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
