Loading CSV files into Oracle tables

pts.
Tags:
Corporate Financial Applications
Database Management Systems
ERP
Financials
Human Resources
Informix
iReceivables
Microsoft Access
Oracle
Payables
Procurement
Projects
I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then use Oracle's SQL*Loader utility to load the data.

Answer Wiki

Thanks. We'll let you know when a new response is added.

There are 6 ways to do it:
1. There is a software, called Oraxel (or something like that)
which connect Excel tables with oracle (and vise versa)

2. You could export your Excel tables into Access and
link Access – Oracle tables through ODBC

3. You could do such export with OEM (Oracle Enterprize
Manager) if OEM is installed on dedicated server

4. If you have a Mictosoft SQL server close by,
link Excel data with Sql server, and then
use DTS (Data transformation services) to populate
oracle tables. You need ODBC or ADO.net configured.

5. If you are comfortable with PL/SQL:
convert your Excel file into .csv format
(right from excel — use export into .csv file);
then write a PL/SQL procedure with UTL_FILE package.
In his procedure you will read line by line your .csv
file and insert a new line into oracle table after that.

6. Use Oracle “External tables” feature to read data
from Excel.

I do not have time to go into details, maybe you got some
ideas

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Daksys
    Using the TOAD V 9.0.1, there is a option to import Excel,CSV and test files direclty into the database tables.
      Right Click on the table and you will find 'Import using Excel,CSV,Text" as an option. Click on the menu item
      Select the tabel you want to import the data into. You can leave he options provided as is or change it as you like..
      Click on the "Show Data" button
      It would display all the data present in the selected table
      Next click on the "Execute Now" button and the wizard open to import the file. From here it should be pretty easy to follwo the wizard
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following