Bill: RBase eXtreme 9.5(64) SU 9.5.3.20611 Win7 Pro / Excel 2013
Recommend: 1. The XLS command-line tag accommodates XLSX no worries; 2. GATEWAY strongly respects certain data formats within Excel: a. Format all dollar currency columns as [ Number ][ 2 ][-negative] b. Format all date columns as [ Date ][ *3/14/2012 ] c. Format all time columns as [ Time ][ 13:30 ] or [ 13:30:55 ] d. BEFORE the import within RBase: SET TIME SEQUENCE HHMMSS (if not already so set) e. AFTER the import within RBase: SET TIME SEQUENCE HHMM (or whatever)(thx D.McGrath) 3. The ADD_MAPPING <ColumnName> = <ExcelColumn> option is ESSENTIAL, especially if you're autonumbering during import. As to the number of records, I've no idea. Is a 64K limit a function of the 9.5(32)? Hope that's useful Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Friday, June 14, 2013 6:26 AM To: RBASE-L Mailing List Subject: [RBASE-L] - File Gateway Import Using the latest update Build: 9.5.3.20611. I have an empty table called FinalRoll with 19 columns. I want to use FileGateway Import to load this table from a Microsoft Excel XLSX file. There is no choice in the FileGateway to Import a MS Excel file with an XLSX extension, only (*.xlsw;xls) extensions. This XLSX file has 19 columns and 72,875 rows. I could split this one file into 2 XLS files that have less than 65,536 rows each so I can utilize the FileGateway. If I try to import the XLSX file the FileGateway goes out to lunch when I click the Next button in the Import Wizard. I can load the table by importing the XLSX file into Access and then ODBC to RBase, but I would rather use FileGateway. Any suggestions ? Bill Eyring
