excel

[#1]

Hi,

In my excel some records are there.

but i dont want to load first 1000 records.

How to solve this issue?

Regards

Anil

[ashfaq_haseeb]

Hi,

Try like this

for first 1000

First 1000

LOAD *

FROM

[yourexcel.xls];

for Greater then 1000

LOAD *

FROM

[yourexcel.xls] where rowno()>1000;

Regards

ASHFAQ

[anbu1984]

Load * From ExcelFile Where RecNo() <= 1000;

[its_anandrjs]

Hi,

Then try this way for rows greater than 1000 rows.

Load * From

ExcelSource Where RecNo() > 1000;

Or

Load * From

ExcelSource Where RowNo() > 1000;

Regards

Anand

[its_anandrjs · Accepted solution]

Hi Anil,

By RecNo() <= 1000 you get only records from 1 to 1000 did you check the result of this expression it should be RecNo() > 1000.

Just for curiosity

Regards

Anand