Creting 1 million dummy records

[edrossi]

I need to find a way to create 1 million records in FoxPro, starting with an empty table. The final result will have the same characters in for 1 million rows and 1 column. Here is an example of what needs to be created:

CODE
-------
NMZ
NMZ
NMZ
NMZ
NMZ
NMZ
NMZ

Any help that can be provided would be greatly appreciated.

Thanks,

E

 

[Stella740pl]

CREATE TABLE MyTable (Code C(3))

FOR i=1 TO 1000000
    INSERT INTO MyTable VALUES ('NMZ')
ENDFOR

 

[StewartUK]

edrossi,

I hope you don't min dme asking, but why do you want to create this table?

Stewart