Dennis I believe you can create a Specification file for Importing the same way you would do it for Export. Using File Gateway select the table to import the spreadsheet from. Then when you get to the Destination/Source screen, only map the Columns (AGK) to the 3 fields you want the data to go into. You will only have do this once ! Before you click next, click on the Specifications button, click Save and enter a file description and modifying the name/location of the specification file (i.e. Test.RGW). Finish the import to test the data loading. Now using a command line like this you can load your files; gateway import xls .vfilename append .vtablename option SPECIFICATION_FILE_NAME test.rgw You could also use GetFileNamePlus.Rbl to select the xls file for vfilename. Check out the Help files under File Gateway for more options. Hope this helps. Bill Eyring
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Monday, June 07, 2010 5:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Import from excel to 7.6 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
