Yeah, a temp table will do the trick. Thanks for all the help!

Thanks to both of you, I got the simplified version to work.  Learned something new!  Here's what I did:

set @openrow1 = 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=' + @dir +...

I've found that some managers will ask you questions to push you to your limits. They want to know how much you know and in what areas. It...