Re: ODBC

Peter,

I assume you mean the exported data is in lower case. To force it to upper case, either use an update query and the ucase() function to force all data to upper case, or use a make table query and the ucase() function.

If the data is already in Oracle, you can use the UPPER function to accomplish the same results.

David
dmlvol_at_aol.com

>Subject: ODBC
>From: "Peter Häusler" Luciver_at_Teleweb.at
>Date: Wed, 20 October 1999 02:05 PM EDT
>Message-id: <awnP3.12670$0t5.78948_at_news.chello.at>
>
>Does anyone knows an ODBC Driver from a third party that can export a table
>from ACCESS to Oracle 8.1.5 in UPPERCASE. The orginal Driver export the
>tables in lowercase and i can work with that.
>
>mfg
>Peter Häusler
Received on Thu Oct 21 1999 - 03:48:12 CEST