Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Portland, Maine, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How do you quickly add test data??

    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

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How do you quickly add test data??

    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.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Portland, Maine, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How do you quickly add test data??

    Thanks Douglas!
    That's just what I needed.[img]/S/smile.gif[/img]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •