Agree with CSV as it will much quicker. Gary
Sent from my Samsung Epic™ 4G TouchTony IJntema <[email protected]> wrote:Save the spreadsheet as CSV and then have an import of the CSV file Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: vrijdag 14 juni 2013 15:26 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
