Makes sense. The funny thing is, that basically mirrors how I was doing it manually before I decided to get fancy....

Okay, here's a slimmed down version of the sp. It assumes the existence of a table named tblResponses, with the following columns: clctID int, questionID varchar(10), userID varchar(10), and...

Sure thing. I'll need to strip out some extraneous stuff, and will post ASAP.

quote:

---

I'd say step out of DTS for a minute, attack this with plain VB or VBScript. Try to write some code or...