>Probably not any faster but, you could try writing the values out to a log file each time the command is run. Then you could review the log file to find out what is going wrong. However, the problem may not be related to the value of the vars and this technique wouldn't give you much else.

Thanks for all your help.

The data transferred much faster than i thought it would, and i stepped through the code. Apparently, the output filename in the insert command is blank. If that's the code blunder, then how is it working in the one office that IS working? hmm...

"Be wary of code that appears to run on the first compile"