I have an excel file with 1000 rows, but I want to load only 120 rows. How to do it?
View solution in original post
Where recno() <=100;
(ooxml, embedded labels, table is Sheet1)
first 120 LOAD
(ooxml, no labels, header is 120 lines, table is Sheet1);
if this is just for testing purposes, you can also execute the reload from with the debugger and use 'Limited Load' and set the number of records to whatever you want.
you can use
First 120 before your LOAD statement