How do you quickly add test data??

Topic

New Reply

I’m looking to create a form similar to the customers Phone list in the NorthWind sample database. I want to quickly add 600,000 records to the 4 fields that display in that phone list. I want to see how sluggish it would be. Is there a way to quickly do this? With an update query? How would I go about doing this??
I’m using Access 97 SR-2.

Thank you
Jols

Reply | Quote

Replies

If you want identical records (other than autonumber fields), make yourself a second copy of your table and two append queries (one to copy from the first to the second and one to copy from the second to the first). Put a single record in the first table (or you could put several in if you want many repetitions of those multiple records). Repeatedly run your two append queries alternately until one of the two tables is the size (to the nearest power of two) that you want. Delete the second table.

Reply | Quote

Thanks Douglas!
That’s just what I needed.

Reply | Quote