Exctract rows from excel random

[Anonymous]

Hello i have a XLS sheet of 1.000 rows. I must extract 5 rows random with almost a city and copy in other xls sheet.

I have tried but i am going crazy.

Please help me. Thank you.

mariostia@hotmail.com

Here there is a xls sample of some rows.

Thanks

[sunny_talwar]

May be use Sample 5 before the LOAD statement to randomly select 5 rows from your table.

Table:

SAMPLE 5

LOAD [Account Code],

          City,

          ...

FROM Source;

[ecolomer]

You can use SAMPLE sentence in LOAD in order ti have some record random

[maxgro]

if you want 5 rows with 5 cities

F:

first 5 load *;

load *

from yourexcel

Where not Exists (City);