>I need to take a project home over the holidays. It's a bit too big and I want to limit the number of records in the tables. I recall seeing a mechanism here not too long ago to pull off samples from tables. For argument's sake let's say that there is no need to worry about relationships or dependencies between tables. I only need 100 or so records out of around 500,000 for the larger tables. Anyone remember this? Nadya, was it you that did this? Thanks!
>
>Regards, Renoir
The fastest would be something like:
use MyTable
copy to c:\offsite\MyTable where recno() % 1000 = 0
(This gets one in every 1000 records. Adjust to fit your needs.)
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)