Pivot Table, MS Query and Oracle

[Monika]

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

[Gary Brown]

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.

[Monika]

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