Success! and a thank you for those who helped.

Some of you may recall my request for information on appending 
information from one
table to another with the difficult part being not introducing new 
duplicate records.
I want to thank those that helped, especially Neil and Tyrael.

I had to first manually delete with care around 1,600 duplicate and 
triplicate lines out of an initial
6,550 records. I would have lost a lot of data using any script. Once 
that was done, I was ready
to try a script suggested by Tyrael. The source for the new data (the 
Tervuren file) had about
11,300 records with no duplicate lines. The destination 'species" 
file sans duplicates now
came in at 4947 records.

After adjusting names and parameters, I ran the script --- and was 
absolutely enthralled that
it worked perfectly. I was also amazed that it took only 0.563 
seconds to go through such a
large collection of names when I though it would take a few minutes! 
Now my TAXA Wood
Knowledge website is reporting a much burgeoned 14,117 wood species 
names :-) :-)
As I had hoped and predicted, this has been a major successful 
advancement in the
project. Much Thanks!

There is one last fact worth sharing ;-) . Because I now have an 
algorithm and typical script
that worked, I have numerous other data lists that later can be 
processed one by one to
grow this total of wood names even much more. It has been a few years 
that I have looked to
having a software tool to do this.

Bill Mudry