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 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 etc...) > > But it was entered in the cells as 101201 > When I formatted the data using the excel option cells -> format > > The data it is displaying in a strage format: 1/27/2177 > > All the date values are displayed improperly. > > Does anybody come across such a situation. How to format the date cells > in excelsheet. > (should I change any options for the sheet) > > Thnx in advance, > > Srinivas > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tatireddy, Shrinivas (MED, Keane) > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > --------------------------------------------------------- > This Mail has been checked for Viruses > Attention: Encrypted mails can NOT be checked! > > ** > > Diese Mail wurde auf Viren geprueft > Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! > --------------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
