Are you familiar enough with ADO to hand-code the query as a macro ?

Tim

--
Tim Williams
Palo Alto, CA


"ovrdrvn" wrote in message
...

OK, we have data in MS SQl Server 2000. Tried a DTS package with a SQL
query that works in Crystal Reports or a tool where I can manually
manipulate layout. Problem comes when I need Excel for a mail merge and
need one row per user.

Was wondering if going from Excel to SQL Server with some programming
might work?


--
ovrdrvn
------------------------------------------------------------------------
ovrdrvn's Profile: http://www.excelforum.com/member.php...o&userid=33573
View this thread: http://www.excelforum.com/showthread...hreadid=533518