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

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 03.25.11.000000000 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: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Change your default date/timestamp format.

Regards
Michel
Re: Excel import [message #595850 is a reply to message #595846] Sat, 14 September 2013 14:16 Go to previous messageGo to next message
Littlefoot
Messages: 18826
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
thatjeffsmith
Messages: 29
Registered: July 2009
Location: Raleigh, NC
Junior Member

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:
http://www.thatjeffsmith.com/archive/2012/04/how-to-import-from-excel-to-oracle-with-sql-developer/
Previous Topic: Error 6 initializing SQL*Plus
Next Topic: Client Sql*Plus version
Goto Forum:
  


Current Time: Fri Apr 18 15:50:56 CDT 2014

Total time taken to generate the page: 0.26100 seconds