data generate one table to another table randomly
 

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