Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Load
RowNo() as ID,
Field1,
Field2
From TableName
Where RowNo() <= 50000;
First 50000
Load fields
From excelsource;
Or
First 50000
Load fields
From excelsource
Order By date;
Hi
use first 50000 in script
First 50000
Load*
from axyj.xls
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