data generate one table to another table randomly

[kickkat]

Hi gurus
i am using visual basic 6.0 and access 2000.
I have table like
1
5
10
20
100
500
1000

i have to generate this table data to another table 2000 or 20000 how many records i want.

second table look likes

1 5 10 20 100 500
10 20 1 500 1000 100
.....
.....
generate 200 or 2000 or 20000 how many records i want.
please help me

thanks in advance.

kickkat

 

[John Big Booty]

Please refrain from double posting