OraFAQ Forum: Client Tools

Home » Other » Client Tools » Excel import (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Excel import [message #595845]

Sat, 14 September 2013 10:51

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)

Report message to a moderator

Re: Excel import [message #595846 is a reply to message #595845]

Sat, 14 September 2013 11:42

Michel Cadot
Messages: 68512
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Change your default date/timestamp format.

Regards
Michel

Report message to a moderator

Re: Excel import [message #595850 is a reply to message #595846]

Sat, 14 September 2013 14:16

Littlefoot
Messages: 21783
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.

Report message to a moderator

Re: Excel import [message #597306 is a reply to message #595845]

Wed, 02 October 2013 21:55

thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC

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/

Report message to a moderator

Previous Topic:	Error 6 initializing SQL*Plus
Next Topic:	Client Sql*Plus version

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 04 13:48:26 CDT 2023