Home » Other » Client Tools » Loading data from Excel to the oracle database
Loading data from Excel to the oracle database [message #266293] Mon, 10 September 2007 07:01 Go to next message
rams1379
Messages: 1
Registered: September 2007
Location: US
Junior Member
Hello,
i have a requirement to load around 100 thousand record's from an excel file to the oracle database.apart from using Toad->import from file option is there a better and efficient way to do this.
thanks.

Report message to a moderator

Re: Loading data from Excel to the oracle database [message #266297 is a reply to message #266293] Mon, 10 September 2007 07:14 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
what your question?

Report message to a moderator

Re: Loading data from Excel to the oracle database [message #266298 is a reply to message #266293] Mon, 10 September 2007 07:17 Go to previous message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Save Excel file as a CSV (comma separated values) file and load it into Oracle table using
a) SQL*Loader,
b) external tables feature.

Report message to a moderator

Previous Topic: Toas sys login
Next Topic: sqlplus timeout
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 17:18:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.