Hi,

I like the approach to solving the problem, but the VBscript seems like overkill. I've also used excel several times to solve these problems. But when they are this easy why not use good old DOS:

FOR /F %i in (custID.txt) do @echo set nocount on select %i >> custID.qry

This solved your problem in just one line of code. For more information on the FOR command, just type "help for" on the command line.

Daniel