Does anyone know if there's a way to do this with CSV files? I tried it exactly as it is presented here, but no luck.
Matthew Burke Pioneer Bank - IT Department Database Administrator 575-627-4415 Office 575-317-5889 Mobile 575-624-3389 eFax [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Monday, September 24, 2012 9:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Tip of the Day: Gateway Import XLS/XLSX Spreadsheet ColumnMapping Monday, September 24, 2012 Tip of the Day: Gateway Import XLS/XLSX Spreadsheet Column Mapping Product: R:BASE eXtreme 9.5 (32/64), R:BASE eXtreme 9.1 (32/64) Section: GATEWAY, Import, Commands, XLS, XLSX Did you know that you can map R:BASE columns to XLS/XLSX spreadsheet columns in order to control the data import into specific locations? Using R:BASE eXtreme 9.5 (32/64) and R:BASE eXtreme 9.1 (32/64), you can include the ADD_MAPPING parameter in the GATEWAY command syntax to map an R:BASE column to the spreadsheet column. Here's how: -- This command will only append Cell B, Cell C and Cell D data into the -- Company, CustAddress and CustState columns of the Customer table from -- the Customer.xls file. GATEWAY IMPORT XLS Customer.XLS APPEND Customer + OPTION ADD_MAPPING Company=B|ADD_MAPPING CustAddress=C|ADD_MAPPING CustState=D Stay productive, my friends! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase www.Razzak.com www.RazzakMemon.com
