Home » RDBMS Server » Server Utilities » data migration from excel file to oracle 9i
data migration from excel file to oracle 9i [message #194230] Thu, 21 September 2006 04:24 Go to next message
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
Re: data migration from excel file to oracle 9i [message #194256 is a reply to message #194230] Thu, 21 September 2006 05:37 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Save with .csv extn and load using SQL loader.
Re: data migration from excel file to oracle 9i [message #194312 is a reply to message #194230] Thu, 21 September 2006 08:09 Go to previous messageGo to next message
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
Re: data migration from excel file to oracle 9i [message #194386 is a reply to message #194230] Thu, 21 September 2006 20:23 Go to previous message
helloanam
Messages: 20
Registered: August 2005
Junior Member
thanks a lot. i am able to migrate data now.
Previous Topic: Automate SQL LOADER in UNIX environment
Next Topic: import - how to make it faster
Goto Forum:
  


Current Time: Wed Dec 25 23:36:29 CST 2024