Home » SQL & PL/SQL » Client Tools » Excel import (oracle 11g)
Excel import [message #595845] Sat, 14 September 2013 10:51 Go to next message
Messages: 96
Registered: December 2012
Location: CHENNAI

I have an Excel file (which has data imported from Oracle 11G Database) one of the fields is a Date Filed which has values like 28-JAN-11 PM ( Date field is Oracle Time Stamp(6) in Database )

When I am trying to Import that Excel file to another Oracle 11 G database (for another database/application), I get an error because the data field is not being recognized by Oracle 11G --> Import is being done by ORACLE SQL Developer (Table (field) has TIMESTAMP(6) as the datatype)
Re: Excel import [message #595846 is a reply to message #595845] Sat, 14 September 2013 11:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Change your default date/timestamp format.

Re: Excel import [message #595850 is a reply to message #595846] Sat, 14 September 2013 14:16 Go to previous messageGo to next message
Messages: 21760
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why don't you use data pump export & import? It is designed for what you are trying to (unsuccessfully) do with an Excel file.
Re: Excel import [message #597306 is a reply to message #595845] Wed, 02 October 2013 21:55 Go to previous message
Messages: 81
Registered: July 2009
Location: Raleigh, NC

Step by step instructions here, be sure not ignore step 4 of 5 where you define how the date is stored in the Excel column mapped to your date or timestamp colunmn:
Previous Topic: Error 6 initializing SQL*Plus
Next Topic: Client Sql*Plus version
Goto Forum:

Current Time: Mon Mar 27 11:31:06 CDT 2023