Hi -
I am using pivot table to fetch data from DQL server. (I am using
ODBC)
The following query

..PivotTableWizard xlExternal,
Array("FILEDSN=c:\hellohi.dsn;UID=hello;PWD=hi", sqlquery), ,
"holdingsTable", False, False, False


goes berserk (throws 'type mismatch' error) if sqlquery contains more
than 250 characters! I am looking at workaround (storing the values I
am sending on the db, and then fetching that data inside the db). Any
ideas?
Why have we all paid so much for this piece of s**t?

-praty77