| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, OLEDB and uppercase problem.
"witek" wrote:
There is still a question if there is a way to change compare method to case nonsenstive instead of unsing upcase function. As far as I know, the JET 4.0 provider is case insensitive (not case sensitive as you imply) and there is no way to specify "Option Compare Text" or "Option Compare Binary". This option exists in Oracle (the default is case sensitive) and SQL Server (the default is case insensitive). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| oledb connection string problem in vb.net | Excel Programming | |||
| Connection to Excel from .Net using Oledb | Excel Programming | |||
| Excel OLEDB format problem... | Excel Programming | |||
| Using OleDB to get data from Excel | Excel Discussion (Misc queries) | |||
| EXCEL AND OLEDB | Excel Programming | |||
Threaded Mode
