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/8b571afd-06a8-426e-80e3-a6aecf63f926n%40googlegroups.com.
