Pivot Table, MS Query and Oracle
 

I use MS Query (+ Oracle) as a datasource for an Excel Pivot table.
Data in one of my fields differs only in case. For example: 'SW K' and 'SW
k'.
Corresponding recordsets shall be differentiated. Results of the SQL query
look
OK in MS Query. But as soon as I give the results back to Excel / Pivot table
the spelling is assimilated (either 'SW K' or 'SW k') which of course
is wrong.
Any solutions, ideas or hints?
Is this maybe a known 'feature' of MS Query? Is MS Query case INsensitive?

Thanks
Monika

Pivot Table, MS Query and Oracle
 

An annoying feature of Excel, and MSQuery, if you create a pivot table
within Excel with both uppercase and lowercase, it ignores the case and
treats them as the case of the first record it finds and as you say
assimilates them.

If you sum the records in MSQuery rather than return each individual
line, you will find MSQuery will group together (irrespective of case)
records with the same data

Excel Pivot tables and MSQuery are case INsensitive.

I don't have a solution, other than use another query tool/appliaction
other than Excel/MsQuery.


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=527085

Pivot Table, MS Query and Oracle
 

Hallo Gary,

thanks for confirming my observations.
So at least I know now that I don't have to look for patches or updates.

Yours
Monika