Try doing the ODBC Query, but tell Excel to generate an OLAP cube file instead of returning the results of to excel directly. This is an option off the last page of the query wizard. You can then run pivot tables off the cube file (a .cub file). You can also save the definition of the cube and then regenerate it simply by opening that definition file (a .oqy extension I believe)
Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. "The more they complicate the plumbing the easier it is to stop up the drain" - Montgomery Scott NCC-1701 ______________________________________________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Kevin King" <[EMAIL PROTECTED]> Sent: Tuesday, October 24, 2006 11:44 AM To: <[email protected]> Subject: [U2] [OT] Excel PivotTable Limitations Is anyone aware of a PC-based tool that one can use to do analyses like Excel PivotTables but without the 65,636 rows by 256 columns limitation of Excel? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
