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

    Unanswered: Export columns in excel sheet to oracle table

    hi ,
    A small problem for which I need your help.

    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
    Oct 2003
    Posts
    1,091
    Yes, I believe it possible. However, this is not my area of work. Here are a couple of links that might prove helpful:

    This lists resources for SQL and Oracle:
    http://www.ozgrid.com/forum/showthre...ghlight=Oracle


    This has various threads related to this topic:
    http://www.ozgrid.com/forum/search.php?searchid=75511

    HTH
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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