Home » SQL & PL/SQL » 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.
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?
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: 20901
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.
Previous Topic: Toas sys login
Next Topic: sqlplus timeout
Goto Forum:
  


Current Time: Fri Dec 09 07:52:55 CST 2016

Total time taken to generate the page: 0.11918 seconds