This works great. The only issue I now have is my dates are coming in as numbers. I know I have seen this in the discussions before.
I'm using an older version of 7.6 so that may be my problem, but perhaps not. Anyone remember this issue? Thanks Dennis ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, June 07, 2010 5:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Import from excel to 7.6 Dennis, I use the specification option through gateway and it works very well. This is a sample of the line code in which you can supply a file name. (.vFileName) GATEWAY IMPORT XLS .vFilename APPEND TmpItem + OPTION specification_file_name MRPINFO.rgw|+ SHEET_INDEX 2 The *.rgw file looks like this : [Common] App=R:BASE 7.5 Description=Gateway Import: specification Specification=MRPINFO DatasetKeys= Mode=0 TableType=XLS SourceFileName=M:\MRP\Item Sales Review.xls CharacterSet=0 [Mappings] Count=6 Map0=ItemNo = A Map1=HighWeek = BH Map2=LowWeek = BI Map3=MRPActive = H Map4=BuildQty = BM Map5=ReOrder = BK [Text] FieldDelimiter=09 TextQualifier=22 RecordSeparator=0D0A Fixed=0 RowFirst=1 RowLast=2147483647 [DataFormat] DateOrder=0 DateSeparator=2F TimeSeparator=3A DecimalSeparator=2E FourDigitYear=1 LeadingZerosInDate=0 and you can map any column you need plus other settings. When you use the GATEWAY interface, you can set everything up and then save it. An *.RGW file will be created. You can then modify this file and use it in a command line prompt as above. -Bob ----- Original Message ----- From: "Dennis McGrath" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, June 7, 2010 4:52:27 PM GMT -06:00 US/Canada Central 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
