Data limit

[#1]

Hi,

in excel file contained 1 Lack rows.

I want only first 50000 by date field,

Already

a 'date' filed column exists in excel table.

And also explain how to retrieve in database?

Regards

k

[MK_QSL]

Load

     RowNo() as ID,

     Field1,

     Field2

From TableName

Where RowNo() <= 50000;

[MarcoWedel]

First 50000

Load fields

From excelsource;

[MarcoWedel]

Or

First 50000

Load fields

From excelsource

Order By date;

[ashwanin]

Hi

use first 50000 in script

First 50000

Load*

from axyj.xls

[its_anandrjs · Accepted solution]

Hi,

There are many ways

1. By load script

First 50000

Load

FieldNames

From Source;

2. By Rowno()

Load

*

From Location

Where Rowno() <= 50000;

2. By pressing Ctrl + E in load script

Then press debug and then define Limited Load and enter no of rows as 50000

Regards

Anand