Just an update on this in case anyone is interested. Rather than using the 'interactive' File Gateway I used two command files with the mapping of the columns specified using the ADD_MAPPING option. Two tables with just under 50,000 rows with 41 & 34 columns were imported quickly and without any issues. While setting up the command files took a while it certainly made the importing a lot easier.
On Wednesday, September 10, 2025 at 5:20:10 PM UTC+12 [email protected] wrote: > Thanks Tony - not sure what happens as I don't see any messages - just the > screen waiting for the Available Tables which remains blank. > > I will try the LOAD option as well as what Bruce has suggested. > > The Excel file I am loading has 71 columns and about 49,000 rows. (It > starts off with 71 worksheets but I have written a program to consolidate > them all into one worksheet - a bit of Delphi code required to achieve > that.) A lot of data to manage, so I split the spreadsheet by columns (one > with columns 1-40 and the other the remaining columns) but it still needs > splitting by rows to import from an XLSX file so I will try the other > options.) > > Thanks, > Regards > John Docherty > > On Wednesday, September 10, 2025 at 12:41:20 AM UTC+12 Tony IJntema wrote: > >> Hi, >> >> In general loading Excel files is not very fast, but it should not stop >> loading. >> >> Have you tried to save the Excel file as an CSV file and then load the >> CSV file using gateway or using the LOAD command >> >> Tony >> >> >> >> Op 09-09-2025 om 12:25 schreef [email protected]: >> > 33 columns and 49000 >> > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/b2732f0d-b02a-41fd-b746-7d395214519dn%40googlegroups.com.
