That is exactly what I would do ... COPY then Paste.

mrh.

thanks for the comments. i may have found my answer with the object.Execute command. which allows you to submit a new query without reopening the connection. (I hope). Will test...