Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Access and Oracle | Excel Discussion (Misc queries) | |||
How to update ORACLE query definition in Excel file | Links and Linking in Excel | |||
Pivot table refresh | Excel Worksheet Functions | |||
Pivot Table - using Countif in place of Count,Sum, etc. | Excel Discussion (Misc queries) | |||
Query of External Data | Excel Discussion (Misc queries) |