OraFAQ Forum: Server Utilities » data migration from excel file to oracle 9i

Home » RDBMS Server » Server Utilities » data migration from excel file to oracle 9i

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

data migration from excel file to oracle 9i [message #194230]

Thu, 21 September 2006 04:24

helloanam
Messages: 20
Registered: August 2005

Junior Member

i want to migrate data from excel file to oracle 9i database. any help would be appreciated.
anam

Report message to a moderator

Re: data migration from excel file to oracle 9i [message #194256 is a reply to message #194230]

Thu, 21 September 2006 05:37

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Save with .csv extn and load using SQL loader.

Report message to a moderator

Re: data migration from excel file to oracle 9i [message #194312 is a reply to message #194230]

Thu, 21 September 2006 08:09

Shamsher
Messages: 18
Registered: September 2006

Junior Member

If you continuing using excel and regularly updating excel sheet I would prefer you to go for ODBC driver connectivity you can synchronize your excel sheet with oracle database.

Regards
Shamsheer

Report message to a moderator

Re: data migration from excel file to oracle 9i [message #194386 is a reply to message #194230]

Thu, 21 September 2006 20:23

helloanam
Messages: 20
Registered: August 2005

Junior Member

thanks a lot. i am able to migrate data now.

Report message to a moderator

Previous Topic:	Automate SQL LOADER in UNIX environment
Next Topic:	import - how to make it faster

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 07:07:14 CDT 2024