Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    24

    Unanswered: Export columns in excel sheet to oracle table

    Hi,

    In an excel sheet I have 2 columns named -- RollNumber and Name

    Now in my oracle database I have a table called Student which also has 2 columns RollNumber and Name..

    This table of mine has 10 records..

    Now I want to add 500 more records.

    The source of these 500 records is the excel sheet which has data in 2 columns.

    Now is there any way to export these 500 records from excel sheet into the oracle table Student.

    So if such a thing is possible it would be very kind of you to let me know what steps I must follow to achieve this task...

    Thanks a lot

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    from Excel store as csv dataset and then use sqlldr to load it

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Save the Excel spreadsheet as a CSV file (comma-separated values). Then write a SQL Loader control script and use it to load the data from the CSV file.

    The control file will look something like this:
    Code:
    LOAD DATA
    INFILE "c:\mydata\students.csv"
    INTO TABLE student
    FIELDS TERMINATED BY ','
    (rollnumber
    ,name
    )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •