How to fetch only 100 rows from an excel data?

[ananyaghosh]

Hi,

I have an excel file with 1000 rows, but I want to load only 120 rows. How to do it?

Thanks,

Sandip

[fvelascog72 · Accepted solution]

Hi,

Use this:

First 120

LOAD

*

FROM....

[swuehl]

LOAD

....

FROM ...

Where recno() <=100;

[ankitaag]

Hi,

LOAD Date,

     Year,

     Month,

     Sales

FROM

(ooxml, embedded labels, table is Sheet1)

where RecNo()<=100;

[prma7799]

first 120 LOAD

*

FROM

[..\..\Downloads\Data Accuracy.xlsx]

(ooxml, no labels, header is 120 lines, table is Sheet1);

[awhitfield]

Hi Sandip,

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.

Andy

[Gabriel]

Hi,

you can use

First 120 before your LOAD statement

First 120

Load

*

FROM .......