Is a temporary table a good solution for importing temporary data into a database
I see 2 ways to do this, your temporary table idea or running them through one at a time.  Which way to go depends on how many records we are talking about.  If its 3 or 4 names at a time then running them individually may be faster but if we are talking larger than 20 or so a temp table would be the way to go.

Overall the best way depends on your requirements.  I use temporary tables for things like this all the time, they are quick and easy and definitely not a "Wrong" choice.

My personal choice would be to write a program to have some one else do it but if that is not an option we see where we go.