Hi lists,
I need to load the excel sheet data to oracle tables. A date column is
improperly entered by users.
In the excel sheet the date column was filled up without using hyphens
or slashes
the data is like this
todays date: 10th Dec 2001
(it is supposed to be 10/12/2001 or 10-Dec-2001
Have you considered to use findreplace tool in excel and replace all the
th string with nothing, and then reformat the cell as you need.
Iulian
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 6:00 PM
To: Multiple recipients of list ORACLE-L
Hi
Workaround: Treat the Column as text (within Excel) and transform it
with a little VBA Macro into the format you want to use in Oracle.
Tatireddy, Shrinivas (MED, Keane) schrieb:
Hi lists,
I need to load the excel sheet data to oracle tables. A date column is
improperly entered by
I was tempted to fall back on my VBA background and give you a bit of code
to fix this nasty habit of your users (101201 = 10th Dec 2001 ! how the heck
are they allowed to do that ???)
Then I realized you're using sqlldr to do the loadingso now you don't have
to mess around with Excel.
So you